Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - clearly labeling

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

IOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 1 T 1E A 7 Based uponyour financial forecas for the years 20232027, compute the folowing, placing your final results in the yellow highlighted area. 2 (t) axs/ Based upon your financial forecast for the years 2023-2027, compute ae below FRDM THE VIE WPOINT OF THE SHARK, 3( What is the growth rate of earnings for each of the forecasted years? Forecasted Income Statement (25 points) DURA-CLEAR WINDOWS, LLC Proforma Income Statement Forecasted Balance Sheet ( 30 points) MILESTONE 2 METRICS SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, or to the side or below - clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 1 (10 points) Based upon your financial forecast for the years 20232027, compute the following ratios, placing your final results in the yellow highlighted area: HINT: It may be helpful to fill out the table below identifying the necessary variables before attempting to compute RNF. \begin{tabular}{l|r|r|r|r|r|} & \multicolumn{1}{|c|}{ 2022 } & \multicolumn{1}{c|}{ 2023 } & \multicolumn{1}{c|}{2024} & \multicolumn{1}{c|}{2025} & \multicolumn{1}{c|}{2026} \\ \hline A & 1,819,500 & 2,998,887 & 3,246,489 & 3,466,236 & 3,794,420 \\ \hline S & 1,875,000 & 3,750,000 & 5,109,375 & 6,386,719 & 7,983,398 \\ \hline change in S & 1,875,000 & 1,359,375 & 1,277,344 & 1,596,680 & 1,995,850 \\ \hline L & 540,000 & 869,278 & 1,167,256 & 1,447,252 & 1,797,248 \\ \hline P & 0.09904 & 0.13608482 & 0.15887802 & 0.171513962 & 0.18142236 \\ \hline S2 & 3,750,000 & 5,109,375 & 6,386,719 & 7,983,398 & 9,979,248 \\ \hline D & 0 & 0 & 0 & 0 & 0 \end{tabular} (Current Assets/ Current Sales) * Change in Sales - (Current Liabilities /Current Sales) * Change in Sales - ( Profit Margin* New Sales * (1-Dividends) Change in Sales = Current Sales for 2022 - Current Sales for 2023 Profit Margin= Net Income/ Current Sales New Sales= Sales during 2023-2027

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Institutions Management

Authors: Anthony Saunders

3rd Edition

007303259X, 978-0073032597

More Books

Students also viewed these Finance questions

Question

What is cultural tourism and why is it growing?

Answered: 1 week ago

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago