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
- Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year: The selling price of Poleskis single product is 16. In recent years, profits have fallen and Poleskis management is now considering a number of alternatives. Poleski wants to have a net income next year of 250,000, but expects to sell only 120,000 units unless some changes are made. The president of Poleski has asked you to calculate the companys projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companys net income objective for next year. Also, compute Poleskis contribution margin per unit, contribution margin ratio, and break-even point for next year. The worksheet CVP has been provided to assist you. Note that the data from the problem have already been entered into the Data Section of the worksheet.The S&H construction company expects to have total sales next year totaling $15,300. In addition, the firm pays taxes at 35 percent and will owe $280,000 in interest expense. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 57 percent of sales and operating expenses will total 32 percent. What is your estimate of firm’s net income after taxes for the coming year? Complete the forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating income Interest expenses Earnings before taxes Taxes Net incomePearson International Publishing Company is trying to decide whether torevise its popular textbook, Fundamental of Corporate Finance. The companyhas estimated that the revision will cost RM65,000. Cash flows for the firstyear is RM18,000 and it will increase by 4 percent per year. The book will berevised back after five years. The initial costs are paid now, and revenues arereceived at the end of each year. If the company requires a 10 percent returnfor the investment, should it undertake the revision.
- You are a consultant who has been hired to evaluate a new product line for Markum Enterprises. The upfront investment required to launch the product line is $7 million. The product will generate free cash flow of $0.76 million the first year, and this free cash flow is expected to grow at a rate of 6% per year. Markum has an equity cost of capital of 10.9%, a debt cost of capital of 5.35%, and a tax rate of 42%. Markum maintains a debt-equity ratio of 0.40. What is the NPV of the new product line (including any tax shields from leverage)? (Round to two decimalplaces.) How much debt will Markum initially take on as a result of launching this product line? (Round to two decimalplaces.) How much of the product line's value is attributable to the present value of interest tax shields? (Round to two decimalplaces.)CelebNav, Inc. had sales last year of $750,000 and the analysts are predicting a good year for the start up, with sales growing 21 percent a year for the next 3 years. After that, the sales should grow 12 percent per year for another two years, at which time the owners are planning on selling the company. What are the projected sales for the last year before the sale? (Round intermediate calculations to 6 decimal places, in all cases round your final answer to the nearest penny.) Projected sales in year 5 $The S&H construction company expects to have total sales next year totaling $14,500,00 In addition, the firm pays taxes at 35 percent and will owe $318,000 in interest expenses. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 58 percent of sales and operating expenses will total 32 percent. What is your estimate of the firm’s net income after taxes for the coming year ? Complete the pro-forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating expenses Interested expenses Earnings before taxes Taxes Net income
- Karen Lamont is in the process of starting a new business and wants to forecast the first year's income statement and balance sheet. She has made several assumptions, which are shown below: Lamont has projected the firm's sales will be $1 million in the first year. She believes that the operating and gross profit margins will be 20 percent and 50 percent, respectively. For working capital, Lamont has estimated the following: Accounts receivable as a percentage of sales: 12% Inventory as a percentage of sales: 15% Accounts payable as a percentage of sales: 7% Accruals as a percentage of sales: 5% A bank has agreed to loan her $300,000, consisting of $100,000 in short-term debt and $200,000 in long-term debt. Both loans will have an 8 percent interest rate. The firm's tax rate will be 30 percent. Lamont will need to purchase $350,000 in plant and equipment. Lamont will provide any other financing needed.Based on Lamont's assumptions in Situation 3, prepare a pro forma income…Noah’s ark video game expects sales to grow by 25% next year. Assume that it pays out 95% of its net income. Using the following statements and the percent of sales method, forecast the amount of net new financing needed.You are a consultant who has been hired to evaluate a new product line for Markum Enterprises. The upfront investment required to launch the product line is $8 million. The product will generate free cash flow of $0.70 million the first year, and this free cash flow is expected to grow at a rate of 6% per year. Markum has an equity cost of capital of 10.8%, a debt cost of capital of 6.38%, and a tax rate of 25%. Markum maintains a debt-equity ratio of 0.50. a. What is the NPV of the new product line (including any tax shields from leverage)? b. How much debt will Markum initially take on as a result of launching this product line? c. How much of the product line's value is attributable to the present value of interest tax shields? Question content area bottom Part 1 a. What is the NPV of the new product line (including any tax shields from leverage)? The NPV of the new product line is million. (Round to two decimal places.) Part 2 b. How much debt will…
- You are a consultant who has been hired to evaluate a new product line for Markum Enterprises. The upfront investment required to launch the product line is $8 million. The product will generate free cash flow of $0.70 million the first year, and this free cash flow is expected to grow at a rate of 6% per year. Markum has an equity cost of capital of 10.8%, a debt cost of capital of 6.38%, and a tax rate of 25%. Markum maintains a debt-equity ratio of 0.50. a. What is the NPV of the new product line (including any tax shields from leverage)? b. How much debt will Markum initially take on as a result of launching this product line? c. How much of the product line's value is attributable to the present value of interest tax shields? Question content area bottom Part 1 a. What is the NPV of the new product line (including any tax shields from leverage)? The NPV of the new product line is $enter your response here million. (Round to two decimal places.)Laura is hoping that an investment of $30,200 will provide additional revenue to the store of $18,100 per year for 3 years. Her partner in crime, Kevin, is confident that a larger investment of $40,000 will be required to bring in a steady flow of $23,200 in new revenue per year for 3 years.Determine the discounted payback period for each investment (using before-tax cash flows). The company’s required rate of return is 9%. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and final answers to 2 decimal places e.g. 15.25.)Click here to view the factor table Laura Kevin Discounted payback period enter discounted payback period rounded to 2 decimal places years enter discounted payback period rounded to 2 decimal places years Whose investment appears to better use the company’s resources?select an optionKevin Chang’s restaurant chain has a net income of $1 million, a dividend payout ratio of 50%, and assets of $8 million. If Kevin wishes his restaurant chain to grow at 10% next year, and his assets must grow with sales and net income, what is his external financing needed? You may calculate the pro-formas assuming the only liabilities that Kevin has are long term debt and retained earnings (equity). **Please explain each step Answer= Needs to fund $800,000 increase in assets. New ΔRE = ($1.1 million *1/2) = $550,000. So the EFN = 800,000-550,000 = $250,000.