Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROSPECTIVE ANALYSIS: Financial Statements 2023 2024 2025 2026 2026 Terminal Total Revenue (or Sales) $ 42,764,900.00 $ 51,317,900.00 $ 61,581,500.00 $ 73,897,800.00 $ 73,897,800.00 $
PROSPECTIVE ANALYSIS:
| Financial Statements | ||||||
| 2023 | 2024 | 2025 | 2026 | 2026 | Terminal | |
| Total Revenue (or Sales) | $ 42,764,900.00 | $ 51,317,900.00 | $ 61,581,500.00 | $ 73,897,800.00 | $ 73,897,800.00 | $ 88,677,400.00 |
| Estimated Annual Revenue Growth Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% |
| Gross Profit | $ 12,829,470.00 | $ 15,395,370.00 | $ 18,474,450.00 | $ 22,169,340.00 | $ 22,169,340.00 | $ 26,603,220.00 |
| Estimated Annual Gross Profit Margin | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% |
| Sales, General, and Administrative Expenses (SG&A) | $ 29,935,430.00 | $ 35,922,530.00 | $ 43,107,050.00 | $ 51,728,460.00 | $ 51,728,460.00 | $ 62,074,180.00 |
| Estimated Annual SG&A (% of Sales) | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% |
| Other Income (Expense) *If expense is reported, enter as a negative number. | ||||||
| Interest Income / (Expense) | $ (238,204.00) | $ (420,493.00) | $ (626,023.00) | $ (767,499.00) | $ (765,620.00) | $ - |
| Other Income (Expense) | $ (115,154.00) | $ 41,725.00 | $ 84,000.00 | $ (618,441.00) | $ 411,214.00 | $ - |
| Net Income (Loss) | $ (17,459,318.00) | $ (20,905,928.00) | $ (25,174,623.00) | $ (30,945,060.00) | $ (29,913,526.00) | $ (35,470,960.00) |
DISCOUNTED CASH FLOW METHOD: Please assist me in answering the below sections as I am not sure I answered the below information correctly so far, thank you.
| Projected for Years Ending December 31, | ||||||
| 2023 | 2024 | 2025 | 2026 | 2026 | Terminal | |
| Forecasted Net Income | $ (17,459,318.00) | $ (20,905,928.00) | $ (25,174,623.00) | $ (30,945,060.00) | $ (29,913,526.00) | $ (35,470,960.00) |
| Plus | ||||||
| Depreciation | $ 35,287,000.00 | |||||
| *Less | ||||||
| Cash Used for Investments | $ (0.49) | [insert value] | [insert value] | [insert value] | [insert value] | [insert value] |
| Cash Used for Financing | $ (3,500,000.00) | [insert value] | [insert value] | [insert value] | [insert value] | [insert value] |
| Net Cash Flow | $ 14,327,681.51 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
| Present Value of Cash Flows | $12,668,153.00 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
| 13.10% | ||||||
| Net Present Value of Future Cash Flows | $1,700,000.00 | |||||
| Net Present Value of Terminal Cash Flow | $335,535.00 | |||||
| 10.60% | ||||||
| Total Indication of Value | $ 2,035,535.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Introduction To Managerial Accounting
Authors: Peter Brewer, Ray Garrison, Eric Noreen
3rd Edition
0073048836, 9780073048833
