Presented is the income statement and balance sheet for PartsCo, a $1.2 billion supplier of machinery parts. The company is expected to increase revenues by 8 percent annually for the next five years. Forecast the next five years of income statements for PartsCo. Assume that the next five years’ forecast ratios are identical to this year’s ratios. Forecast depreciation as a percentage of the prior year’s property, plant, and equipment. Forecast interest as a percentage of the prior year’s total debt. $ millionPrior Current Forecast Forecast Forecast Forecast Forecastyear1,100.0 1,188.0Income statementyearyear 1year 2 year 3 year 4 year 5RevenuesCost of sales(825.0)(891.0)Selling costsDepreciationOperating profit(165.0)(178.2)(27.6)(29.7)82.489.1(15.0)Interest expenseEarnings before taxes(15.0)67.474.1Тахes(20.2)(22.2)51.9Net income47.2Dividends19.021.0Prior Current Forecast Forecast Forecast Forecast ForecastBalance sheetyearyearyear 1 year 2 year 3 year 4 year 5AssetsWorking cash22.023.8Excess cash and marketable securities385.2377.6Accounts receivable110,0118.8Inventory123.8133.7Current assets641.0653.9Property, plant, and equipment440.0475.2Equity investments320.0320.0Total assets1,401.0 1,449.1Liabilities and equityAccounts payable123.8133.7Short-term debt90.090.0Accrued expenses88.095.0Current liabilities301.8318.7210.0210.0Long-term debtNewly issued debtCommon stock150.0150.0Retained earningsLiabilities and equity739,2770.41,401.01,449.1

The income statement determines the net income of the business by subtracting the total expenses…

Answered: Forecast Forecast Forecast Forecast…

Business

Accounting

Forecast Forecast Forecast Forecast Forecast year 1 year 2 year 3 year 4 year 5

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter4A: Nopat Breakeven: Revenues Needed To Cover Total Operating Costs

Section: Chapter Questions

Problem 1EP

See similar textbooks

Similar questions

Year Net Cash Flow Discount Factor Present Value (using the factor) Present Value (using Excel formula) 0 $ (3,500,000.00) 1 $ (3,500,000.00) ($3,500,000.00) 1 $ 900,000.00 0.90909 $ 818,181.00 $818,181.82 2 $ 900,000.00 0.82645 $ 743,805.00 $743,801.65 3 $ 900,000.00 0.75131 $ 676,179.00 $676,183.32 4 $ 900,000.00 0.68301 $ 614,709.00 $614,712.11 5 $ 900,000.00 0.62092 $ 558,828.00 $558,829.19 Net Present Value $ (88,298.00) $ (88,291.91) 3. Now assume that inflation is estimated as a 5% increase each year (starting with Year 1) for the entire 5 years. Calculate the new net cash flow values for each year. start with 5% increase for Year 1 net cash flow. Year Net Cash Flow 0 $…
NPV(Net Present Value) with discount rate is 6% for this period and cashflow as followed. Period 0, Cashflow ($150,000) Period 1, Cashflow $70,000 Period 2, Cashflow $80,000 Net present value is 71,198. Payback period is 2 years. Please elaborate in detail the obvious problem with using the payback method (Profit Index, NPV, IRR & Time Value Of Money).
Payback period and discounted payback period (using 5% rate of return) Initial Investment is 300,000 Net Income July 36,000 August 12,300 September 21,000 October 9,600 November 17,650 December 61,500
Assuming a 1-year, money market account investment at 5.315.31 percent (APY), a 3.413.41 percent inflation rate, a 2828 percent marginal tax bracket, and a constant $70 comma 00070,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 5.315.31% (APY), a 2828% marginal tax bracket, and a constant $ 70 comma 000$70,000 balance, the after-tax rate of return is enter your response here%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 5.315.31% (APY), a 2828% marginal tax bracket, and a constant $ 70 comma 000$70,000 balance, the after-tax monetary return is $enter your response here. (Round to the nearest dollar.) Part 3 Given an after-tax return of 3.823.82% and an inflation rate of…
Forecast 2020 income statement and balance sheet using the percent of sales method and the following assumptions: (1) sales in 2020 will be 12.5 million; (2) tax rate keeps the same; (3) each item that changes with sales will be the 2 year average percentage of sales; (4) fixed asset will increase $1,000,000 with a 10 year straight line depreciation schedule with 0 salvage value; (5) the common stock dividends will be $202,000; (6) interest rate on short-term and long-term debt will be 9%; (7) Cash , short-term investment will be the same as 2019; (8) COGS, Selling G&A expenses, A/R, inventory, A/P, Accruals will change in proportion to sales; (9) Notes payable and long-term debt will keep the same; and if there is borrowing need, the company will borrow from long-term debt; (10) the company will not issue stocks in 2020. a) What is the additional funds needed in 2020? Is this a surplus or deficit or balanced? (Without iteration, or borrowing happens at last day of the year) b)…
Amount Desired at End of Period Length of Time Rate Compounded $ 17,600.00 7 2% Quarterly Required: Complete the following using the information above and the present value Table 12.3 or the present value table in the Business Math Handbook or the present value formula to answer the following: Period Used Rate Used PV factor used PV of amount desired at end of period
Investment End of Year A B C 1 $ 13,000 $ 18,000 2 13,000 3 13,000 4 13,000 5 13,000 $ 13,000 6 13,000 54,000 7 13,000 8 13,000 9 13,000 10 13,000 18,000 Assuming an annual discount rate of 23 percent, find the present value of each investment. a. What is the present value of investment A at an annual discount rate of 23 percent? b. What is the present value of investment B at an annual discount rate of 23 percent? c. What is the present value of investment C at an annual discount rate of 23 percent?
Q1Muscat Video Products’ sales are expected to dencrease from OMR (S0 = 8) million in 2019 to OMR (S1= 7) million in 2020. Its assets totaled (TA)OMR 6 million at the end of 2019. Muscat company is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities (TCL) were OMR (2) million. The net profit margin (NPM) is forecasted to be 4%, and payout ratio .(D) is 30% Is muscat company needs fund from external or internal to finance the new sales in 2020? .And why
Y2 Aportfolio manager states that the return for the period is 5.34 per cent by using the following annual rates of returm Year. Return 1. 6% 2 -37% 3. 27% What type of rate of return (HPR AM or GM) said by the manager and why?
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…