The most recent balance sheet and income statement for JPX (2020) is provided in the attached...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The most recent balance sheet and income statement for JPX (2020) is provided in the attached spreadsheet (sheet Q1). The target sales growth rate for 2021 is 15%. All spontaneous assets as well as| spontaneous liabilities are expected to grow with sales. Assume the firm is operating at full capacity. Information on operating and financing assumptions are provided in the attached spreadsheet. Further, partially completed projected balance sheet and income statement for 2021 are also included. a) Using the percent sales method of financial forecasting, project the remaining balance sheet and income statement items for 2021 assuming any additional funds needed are obtained by issuing long-term debt. Estimate the Additional Financing Needs (AFN) for 2021? b) Estimate the free cash flows for 2021 c) Conduct a Dupont Analysis for 2021 Operating and Financing Assumptions Sales Growth Tax Rate Payout Ratio Operating Income/Sales Cash/Sales AR/Sales Inventories/Sales Net Fixed Assets/Sales Acc Payable/Sales Accrua/Sales t of Borrowing for short and long term debt rce of External Financing -Plug item 15.00% 20.00% 40.00% 22.67% 2.12% 3.18% 6.14% Income Statement 2020 2021 $ 4,720 $ $ 3,050 200 24 158.90% Sales 5,428 9.53% Cost of Goods Sold 8.47% 14% Selling General and Admin E: $ Depreciation EBIT 400 $ 1,070 $ 2$ Long Term Debt 1,231 Interest Expense 350 Earnings Before Taxes 24 720 A- Estimate AFN using Financial Forecasting Method B- Estimate Free Cash Flow to Firm in 2021 C- Conduct Du Pont Analysis for 2021 Net Income %24 576 Dvidends 230 Addition to Retained Earning: $ 346 Actual Projected Balance Sheet 2020 2021 Surplus Cash 100 $ 115.00 %24 Cash 24 Acc Receivable 150 Inventory 290 $ 333.50 Total Current Assets 540 $ 7,500 $ 8,040 Net Fixed Assets Total Assets Liab + Shareholder Equity Accounts Payable 450 400 $ 460.00 690 $ Accruals Notes Payable 2$ 690.00 Total Current Liab 1,540 Long Term Debt 2,000 3,050 $ 3,050.00 1,450 Common Stock Retained Earnings Total Liab +SE 8,040 Proj Assets Proj Liab AFN The most recent balance sheet and income statement for JPX (2020) is provided in the attached spreadsheet (sheet Q1). The target sales growth rate for 2021 is 15%. All spontaneous assets as well as| spontaneous liabilities are expected to grow with sales. Assume the firm is operating at full capacity. Information on operating and financing assumptions are provided in the attached spreadsheet. Further, partially completed projected balance sheet and income statement for 2021 are also included. a) Using the percent sales method of financial forecasting, project the remaining balance sheet and income statement items for 2021 assuming any additional funds needed are obtained by issuing long-term debt. Estimate the Additional Financing Needs (AFN) for 2021? b) Estimate the free cash flows for 2021 c) Conduct a Dupont Analysis for 2021 Operating and Financing Assumptions Sales Growth Tax Rate Payout Ratio Operating Income/Sales Cash/Sales AR/Sales Inventories/Sales Net Fixed Assets/Sales Acc Payable/Sales Accrua/Sales t of Borrowing for short and long term debt rce of External Financing -Plug item 15.00% 20.00% 40.00% 22.67% 2.12% 3.18% 6.14% Income Statement 2020 2021 $ 4,720 $ $ 3,050 200 24 158.90% Sales 5,428 9.53% Cost of Goods Sold 8.47% 14% Selling General and Admin E: $ Depreciation EBIT 400 $ 1,070 $ 2$ Long Term Debt 1,231 Interest Expense 350 Earnings Before Taxes 24 720 A- Estimate AFN using Financial Forecasting Method B- Estimate Free Cash Flow to Firm in 2021 C- Conduct Du Pont Analysis for 2021 Net Income %24 576 Dvidends 230 Addition to Retained Earning: $ 346 Actual Projected Balance Sheet 2020 2021 Surplus Cash 100 $ 115.00 %24 Cash 24 Acc Receivable 150 Inventory 290 $ 333.50 Total Current Assets 540 $ 7,500 $ 8,040 Net Fixed Assets Total Assets Liab + Shareholder Equity Accounts Payable 450 400 $ 460.00 690 $ Accruals Notes Payable 2$ 690.00 Total Current Liab 1,540 Long Term Debt 2,000 3,050 $ 3,050.00 1,450 Common Stock Retained Earnings Total Liab +SE 8,040 Proj Assets Proj Liab AFN
Expert Answer:
Answer rating: 100% (QA)
1a EFN AS x Sales LS x Sales PM x FS x 1d A S Assets that change given a change in sales expressed a... View the full answer
Related Book For
Contemporary financial management
ISBN: 9780324289114
10th Edition
Authors: James R Mcguigan, R Charles Moyer, William J Kretlow
Posted Date:
Students also viewed these accounting questions
-
The most recent balance sheet and income statement of Helle Corporation appear below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Cash and cash...
-
A comparative balance sheet and income statement for Eaton Company follow: During 2008, the company sold some equipment for $18 that had cost $30 and on which there was accumulated depreciation of...
-
The Garcia Industries balance sheet and income statement for the year ended 2005 are as follows: Income Statement (in Millions of Dollars) Net sales ............... $100.0 Cost of sales...
-
Knoko Systems is considering a capital budgeting project with a life of five years that requires an outlay of $90,000. It has free cash flows each period as shown in the following distribution:...
-
Fortune magazine publishes an annual list of the 100 best companies to work for. The data in the file named FortuneBest shows a portion of the data for a random sample of 30 of the companies that...
-
An engineer is assigned to design an electrochemical cell that will deliver a potential of exactly 1.52 V. Design and sketch a cell to provide this voltage, detailing the solutions, their...
-
What are the functions of the following in an I.C. engine ? (a) Piston (b) Crankshaft (c) valve gear mechanism.
-
McDonald's Corporation franchises and operates more than 36,000 fast-service restaurants around the world. Buffalo Wild Wings franchises and operates more than 1,000 restaurants in North America....
-
Problem 3: Draw the isometric view of the part whose orthographic projects are shown below. Show hidden lines.
-
Required: Nancy, who is 59 years old, is the beneficiary of a $220,000 life insurance policy. What amount of the insurance proceeds is taxable under each of the following scenarios? (Do not round any...
-
E be a set in a metric space and E' be the set of all limit points of E. Is it possible that both E and E' have the same set of limit points? Justify your answer.
-
Consider the following two models where $E(\boldsymbol{\varepsilon})=\mathbf{0}$ and $\operatorname{Var}(\boldsymbol{\varepsilon})=\sigma^{2} \mathbf{I}$ : Model A: $\mathbf{y}=\mathbf{X}_{1}...
-
Let $\mathbf{x}_{j}$ be the $j$ th row of $\mathbf{X}$, and $\mathbf{X}_{-j}$ be the $\mathbf{X}$ matrix with the $j$ th row removed. Show that \[\operatorname{Var}\left[\hat{\beta}_{j}...
-
For the multiple linear regression model, show that $S S_{\mathrm{R}}(\boldsymbol{\beta})=\mathbf{y}^{\prime} \mathbf{H y}$.
-
Let $R_{j}^{2}$ be the coefficient of determination when we regress the $j$ th regressor on the other $k-1$ regressors. Show that the $j$ th variance inflation factor may be expressed as...
-
Consider a correctly specified regression model with $p$ terms, including the intercept. Make the usual assumptions about $\varepsilon$. Prove that \[\sum_{i=1}^{n}...
-
Students should replace the ## with the last two digits of their student number. The measurements are in feet. Use the last two digits of your student # as benchmark elevation. BS (+S) FS (-S) BM 1...
-
Find a polar equation for the curve represented by the given Cartesian equation. 4y 2 = x
-
What effect do share repurchases (undertaken as part of the firms dividend decision) have on the value of the firm?
-
Consider the Leverage Unlimited, Inc., zero coupon bonds of 2008. The bonds were issued in 1990 for $100. Determine the yield to maturity (to the nearest 1/10 of 1 percent) if the bonds are purchased...
-
Ellingtons Cabaret is planning a major expansion that will require $95 million of new financing. Ellingtons currently has a capital structure consisting of $400 million of common equity (with a cost...
-
Amherst Metal Works produces two types of metal lamps. Amherst manufactures 20,000 basic lamps and 5,000 designer lamps. Its simple costing system uses a single indirect-cost pool and allocates costs...
-
Amherst Metal Works produces two types of metal lamps. Amherst manufactures 20,000 basic lamps and 5,000 designer lamps. Its activity-based costing system uses two indirect-cost pools. One cost pool...
-
How do managers refine a costing system?
Study smarter with the SolutionInn App