Pro Forma Financial Statements income Statement Sales Costs Except Depreciation EBITDA Depreciation EBIT Interest Expense (net) Pre-tax Income Income Tax Net Income $214,163 (110,332) $103,831 (6,535) $97,296 (628) $96,668 (33,834) $62,834 Balance Sheet Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant, and Equipment Total Assets Liabilities and Equity Accounts Payable Debt Total Liabilities Stockholders' Equity Total Liabilities and Equity $16,530 2,204 4,430 $23,164 10,921 $34,085 $1,719 3,900 $5,619 $34,493 $40,112
Q: Hybrid cars are touted as a "green" alternative; however, the financial aspects of hybrid ownership…
A: Variables in the question:List price of hybrid car more than the gasoline only car=$ 5800Annual…
Q: You are bullish on Telecom stock. The current market price is $62 per share, and you have $6,200 of…
A: The maintenance margin is the margin that denotes the smaller equity value that must be kept by the…
Q: You are bullish on Telecom stock. The current market price is $62 per share, and you have $6,200 of…
A: A margin call is a call where the equity amount has to be raised into the account by the brokerage…
Q: Consider a project with an initial investment (today, t = 0) of $200,975. This project will generate…
A: Profitability Index is also known as PI. It is a capital budgeting technique which helps in decision…
Q: Suppose Caterpillar, Inc., has 658 million shares outstanding with a share price of $75.47, and…
A: Current Equity = 658millionshares∗$75.47=>Current Equity =$49,659.26million or $49.66billionNote…
Q: A nominal risk-free rate is currently 3.5%. A broker at INV Securities, has given you the following…
A: Liquidity risk premium and default risk premium are both taken into account to calculating short…
Q: | Six years ago the Templetion Company, issued 18- year bonds with a 14% anual Coupon rate at their…
A: The realized rate of return on holding a bond till it is called refers to the actual return an…
Q: Synovec Company is growing quickly. Dividends are expected to grow at a rate of 20 percent for the…
A: The dividend discount model will be used here. As per the dividend discount model the value of a…
Q: a. with 6+ decimals. You will receive $10 million in 12 monthly payments (of one million each)…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: u are planning to save for retirement over the next 35 years. To do this, you will invest $700 a…
A: Money invested in the stock market and bonds would grow to much larger amount due to the compounding…
Q: Evans Emergency Response bonds have 5 years to maturity. Interest is paid semiannually. The bonds…
A: Yield to maturity is the total return a bondholder has earned by holding the bond until its…
Q: You want to have $40,000 in your savings account 6 years from now, and you're prepared to make equal…
A: The concept of time value of money will be used here and that of annuities. The amount of $40,000 is…
Q: Margaret has an investment opportunity where she can receive cashflows as follows 1. $1,000 end of…
A: The present value is calculated by The present value of perpetuity is
Q: Mball has just purchased a car for R342 000. The bank offered her a 5 year finance plan with monthly…
A: “Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only…
Q: You have been given the following information for an existing bond that provides coupon payments.…
A: Present avlue is a current value of future cash flow at specified rate of interest. It is helpful in…
Q: You are looking at a one-year loan of $10,000. The Interest rate is quoted as 9.7 percent plus two…
A: Here loan amount = $10000Rate of interest = 9.7%So total loan repayment amount = 10000 * (1+9.7%) =…
Q: Your company is contemplating the acquisition of an aged commercial property that's expected to be…
A: A commercial property lease is a legally binding agreement between a property owner and a business…
Q: ontent area top Part 1 You have an outstanding student loan with required payments of $550 per…
A: We need to first calculate total loan outstanding today by using PV function in excel, Thereafter…
Q: Your firm has an ROE of 12.1%, a payout ratio of 21%, $632,800 of stockholders' equity, and $425,900…
A: Sustainable growth rate is the growth rate at which a company can grow if its current capital…
Q: Why is it a challenge performing data analysis in Excel without the Power BI tools?
A: Power BI is based out of Business intelligent Platform. It provides nontechnical business users with…
Q: What is the price of a bond with the following features? 5 years to maturity, face value of $1000,…
A: A bond is a kind of debt security issued by the government and private companies to the public for…
Q: Halliford Corporation expects to have earnings this coming year of $2.765 per share. Halliford plans…
A: As per the dividend growth or the dividend discount model, the share's current price denotes the…
Q: You would like to know how much you need to save and invest monthly to have $1 million in your…
A: A constant and fixed sum of cash flow in each period is an annuity. Here the future desired value or…
Q: When your firm hires a new employee this year, it is obligated to contribute GBP £5,000 to a defined…
A: Given, the amount contributed is GBP 5000Inflation (growth rate) is 2%rate of return is 10%period is…
Q: CHALLENGE Walker's Gunnery, a small arms manufacturer, has current sales of $10 million and…
A: Financial structure, in the context of a business or organization, refers to the mix of different…
Q: The capital allocation process involves the transfer of capital among different entities that…
A: Investment bank- Such banks help companies with complex financial transactions i.e., facilitating…
Q: Suppose you invest $120 a month for 8 years into an account earning 10 % compounded monthly. After 8…
A: Compound = monthly = 12monthly Payment = p = $120Interest Rate = r = 10 / 12%Number of Payment = n =…
Q: The mortgage on your house is five years old. It required monthly payments of $1402, had an original…
A: “Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: Curwin has R3003650,00 saved for his retirement. His account earns 8,4% interest per annum,…
A: Present value of payments that can be withdrawn should be equla value of deposit today based on the…
Q: You just purchased a share of stock at a cost of $25. You expect the stock to pay you a dividend at…
A: Total return of a security comprises of current income that can be in the form of dividend or…
Q: Consider the following cash flows of two mutually exclusive projects for AZ-Motorcars. Assume the…
A: Payback period=Years before break-even+Unrecovered amount/Cash flow in recovery yearNPV=PV of cash…
Q: eBook the future values of these ordinary annuities. Compounding occurs once a year. Do not round…
A: Future value is the estimated value of current assets that is discounted at an assumed rate of…
Q: what would the estimated value for the property
A: Cash flows: $2,110,000Growth rate: 4%Required rate of return :13%
Q: The Utah Mining Corporation is set to open a gold mine near Provo, Utah. According to the treasurer,…
A: IRR is considered as one of the most important Capital Budgeting Techniques. It is the rate(discount…
Q: Consider a bond with a 3% annual coupon and a face value of $1000. Complete the following table.…
A: Bonds are debt instruments issued by companies. The issuing company pays periodic interest (called…
Q: Tanaka Machine Shop is considering a 4-year project to improve its production efficiency Buying a…
A: The net present value is the difference between the present value of the future cash flows and the…
Q: At the end of its third year of operations, the Sandifer Manufacturing Co. had $4,559,000 in…
A: Given: Revenues = $4,559,000 Cost of Goods Sold = $3,555,000 Operating Expenses = $458,000 Tax Rate…
Q: An investment under consideration has a payback of seven years and a cost of $870,000. Assume the…
A: This question is concerned with two important capital budgeting tools of payback and NPV. Payback is…
Q: You purchased one hundred shares of MSFT for fifty dollars per share using a sixty percent initial…
A: A margin account refers to a brokerage account where the investor only has to provide a part of the…
Q: i) The expected return in boom economy for all the three stocks. ii) The expected return in bust…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Which of the following is NOT true of insurable risks? Risks can be insured even if they are not…
A: Insurable risk are the riska that an Insurance company will cover.For example - Fire risk, flood…
Q: Present value: Mixed streams Consider the mixed streams of cash flows shown in the following table,…
A: Present value is the value of a cash flow today i.e. as of now. This is based on the concept of time…
Q: Project L requires an initial outlay at t = 0 of $59,000, its expected cash inflows are $10,000 per…
A: Initial Investment = i = $59,000Annual Cash Flow = cf = $10,000
Q: Annual revenue for a company grew by 5.4% in 2014, 1.2% in 2015, -3.6 % in 2016, -1.2% in 2017, and…
A: Mean growth is the goemetric averge of the five years of growth considering the impact compounding…
Q: Simple versus compound interest nancial contracts involving investments, mortgages, loans, and so on…
A: Simple interest is simple in nature That means no interest in interest is there but in compounded…
Q: You would like to know how much you need to save and invest monthly to have $1 million in your…
A: Future value is a financial term that refers to the value of an investment or asset at a specific…
Q: Find the future values of the following ordinary annuities: a. FV of $400 paid each months for 5…
A: An annuity is a financial product that involves a series of regular payments or receipts made at…
Q: Find the APR (true annual interest rate), to the nearest half percent, for the following loan.…
A: Finance charge per $100 of amount financed =
Q: Assume the following ratios are constant: Total asset turnover Profit margin Equity multiplier…
A: As per DuPont equation, the return on equity is
Q: (Future value of a complex annuity) Springfield mogul Montgomery Burns, age 80, wants to retire at…
A: There is need of planning for the future based on the future needs and requirement based on time…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
- Example : You want to buy a $18,500 car. The company is offering a 3% interest rate for 4 years. What will your monthly payments be? I will do this one for you and show you how I want you to describe your formula/inputs in excel if that is how you choose to go about solving problems 2 through 5 - which I strongly recommend. If you choose to perform the calculations by hand show the formula used with values. Excel: Formula used: PMT Rate input: .03/12 NPer input: 4*12 Pv input: 18500 Answer : $409.49 per month 2. You want to buy a $22,500 car. The company is offering a 4% interest rate for 5 years. a.What will your monthly payments be? Round to the nearest cent .b. Assuming you pay that monthly amount for the entire 5 years, what is the total amount of money you will pay during those 5 years for the car? c.How much interest will you pay during those 5 years?Your company is expected to earn (as a cash flow) $3 million next year, $3.06 million the following year, $3.1212 the year after that, and it will continue to grow by 2% per year indefinitely. Using a discount rate of 8%, what is the value of the company? (Do not round intermediate calculations. Report your result in millions of dollars. Round the final answers to 2 decimal places. Omit $ sign and the word “million” in your response. For example, if your answer is $1,234,567 just write 1.23.)Without using excel, answer the question: An investor takes a loan for $40000 to purchase inventory to start a business. The terms of the investors loan state that the interest rate is 12%, interest is compounded monthly and payments will be made in 12 equal end of month payments. How much would the investor need to pay in month 7
- Company investment says will pay out $64,000 at the end of 3 years. To invest, you'll need to deposit $9,900 to their bank account and keep the information private. What is the average annual return on this investment? Remember to use a TVM function. the answer is provided: 86.29% Please show how to get on EXCEL in one functionSuppose you own a business and you expect to generate a profit of $50,000 next year. Each year after that you expect your profit to grow by 4%. If you earn profits for 10 years total and the discount rate is 8%, what is your company’s valuation today (present value)? (Show layout in Excel Please)Give correct typing answer with explanation and conclusion to all parts Biochemical Corp. requires $540,000 in financing over the next three years. The firm can borrow the funds for three years at 11.80 percent interest per year. The CEO decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 8.50 percent interest in the first year, 12.90 percent interest in the second year, and 9.75 percent interest in the third year. Assume interest is paid in full at the end of each year. a. Determine the total interest cost under each plan. Long-tern fixed rate-Interest cost Short-term variable rate-Interest cost b. Which plan is less costly? multiple choice Short-term variable-rate plan Long-term fixed-rate plan
- Please calculate the interest that has been accrued as of December 31, 2014 in the given scenario. You invest $90,000 with a small business that has promised to pay you interest at a 6.5% rate. After 210 days, the small business will return the $90,000 plus interest to you. You invest with the business on August 1, 2014.You are preparing the business plan for a new company. A net revenue analysis covering the first 6 years is required for obtaining financing. Net revenue in year 1 is expected to be $50,000 and increase by 15% each year, thereafter. If i = 12% and the net revenue is assumed to be an end-of-year cash flow, what is the present value of the cash flow series over the 6 years?The Martins know that setting up some projected Income Statements are important. They need to look at what the first year of operations might look like and if possible they will need to look at the years thereafter to get an impression of what the long term might look like. RM Purchases: $132,000* (Raw Material Purchases is a part of COGS) Sales Salaries: 80,000 Advertising: 3,000 Travel: 2,000 Revenue: 360,000 Financing Costs: 10,000 Office Lease: 13,000 Depreciation: 38,000 Income Taxes: 22,000 Admin Salary: 40,000 A second financial statement that is key to understanding a business is the Balance Sheet. The Martins have estimated the following accounts to be a part of their initial Balance Sheet. Trade Receivables: $35,000 Cash: 15,000 Short Term Loan: 30,000 Share Capital: 100,000 Long Term Liabilities: 60,000 Property, Plant:…
- I need the manual excel formula as well as the FV Excel Function. C. Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how much will you have at the end of the periods? Formula $ ??? Excel Functon $1,066,616.08Using the life cycle approach to financing, create a financial plan for a startup company that requires $1,000,000 in funding to launch its operations. Assume that the company will require additional funding of $ 500,000 in two years and $1,000,000 in five years to support its growth. Assume an interest rate of 8% on debt financing, the debt financing for each year will have a debt service payment of $20,000 per year. HINT: the life cycle lasts 5 years. YearGood day! Can you please help me with this? Thank you!! Financial Forecasting SOLVE THE FOLLOWING PROBLEM: Use the percentage of sales forecasting method to compute the additional financing needed by LSS Inc., if sales are expected to increase from a current level of P 20,000,000 to a new level of Php 25,000,000 over the coming year. LSS expects earnings after taxes to equal Php 1,000,000 over the next year (2018). LSS intends to pay a Php 300,000 dividend next year. The current year balance sheet for LSS is as follows: LSS INC. Balance Sheet as of December 31, 1018 Cash 1,000,000c. Additional financing needed Accounts Payable 3,000,000Accounts Receivable 1,500,000 Notes Payable 3,000,000Inventories 6,000,000 Long term Debt 2,000,000Net Fixed Assets 3,000,000 Stockholder’s Equity 3,500,000TOTAL ASSETS 11,500,000 TOTAL LIABILITIES &EQUITY 11,500,000 All assets except “cash are expected to vary proportionately with sales. Of total liabilities and equity, only “accounts payable” is…