[ORDER] MILESTONE 3: Analysis of Forecasted Financials (60 points)

$ 89.44

MILESTONE 3: Analysis of Forecasted Financials (60 points)

Milestone 3 provides a 5-year forecasted Income Statement and a 5-year forecasted Balance Sheet from which you will analyze your financials using CVP analysis to determine breakeven and other metrics. You will also apply capital budgeting techniques to determine the profitability of your forecasted financials from the standpoint of your investor. Based on your analysis, you will answer questions about your results. See the Course Project Milestone 3 template for additional details and requirements.

Order Now
Category:
Order This Paper

MILESTONE 3: Analysis of Forecasted Financials (60 points)

 

Milestone 3 provides a 5-year forecasted Income Statement and a 5-year forecasted Balance Sheet from which you will analyze your financials using CVP analysis to determine breakeven and other metrics. You will also apply capital budgeting techniques to determine the profitability of your forecasted financials from the standpoint of your investor. Based on your analysis, you will answer questions about your results. See the Course Project Milestone 3 template for additional details and requirements.

ItemGrading CriteriaPoints Possible MetricsAll work shown in a well-labeled, easy-to-follow format5 Accuracy of result35 Questions 1 – 4All parts of question fully answered and response shows thought and some depth of analysis4 points per question Limited or no errors in spelling, grammar, sentence structure or use of language1 point per question Total 60 points

SCENARIO: You invented “Dura-Clear windows” that never need washing!  Nothing sticks to them – not pollution, pollen, dirt, dust, bird droppings, fingerprints, nothing. You’ve invested all your own savings, your parents’ savings, and some of your friends’ savings as well into the R&D, production, and start-up of your business.  It’s been three years since you started selling your windows primarily to single-family homeowners, but now apartment building contractors across the nation have been requesting your windows. Unfortunately, you’re already operating at full capacity.  It’s time to make the switch from single-family homes to commercial buildings, but to do so requires a large infusion of funding for expansion.  You need more of everything:  space, equipment, employees, etc.

Ever the optimist, you applied to the TV show Shark Tank–where entrepreneurs compete for funding from angel investors (“sharks”)–to see if a shark will invest in your company and serve as a mentor as well. To your surprise, you were accepted to the show!  You’ve already prepared most of your marketing and sales pitches, and now it’s time to put together your forecasted financial statements.  You intend to show the sharks that backing your business would be a very profitable investment.  You also need to determine how much funding to ask for in exchange for how much ownership you’ll give up.

The following 2 Notes apply!

NOTE 1:  You must show ALL your work.  Either

Note: Full answer to this question is available after purchase.
your computations are in the cell behind your result, or you must place them out to the right on the Forecasted Financials tab. If you choose to show your work out to the right, show all steps and label your work clearly so it can be understood.

NOTE 2:  Do not round computations until you have found your final answer.  Then, round your result to the nearest dollar.  No pennies!

REQUIREMENTS:

MILESTONE 3:  Analysis of Forecasted Financials (60 points)

Milestone 3 is a continuation of the Course Project scenario.  However, in Milestone 3, the forecasted financial statements are provided to you on the “Milestone 3 Financial Stmt data” worksheet.  Do NOT use your forecasted financial statements from Milestone 2.  Instead, use the data provided in this template to compute your metrics and answer questions.

You have created forecasted financials making the assumption that the sharks will provide the $1M in funding you are requesting for expansion.  Now you need to determine the profitability of your proposal.

REQUIRED:

(40 pts) Using the “Milestone 3 Financial Stmt data” given in this template, compute several profitability measures as identified on the Milestone 3 Metrics worksheet.  Place your answers to the following directly on the Milestone 3 Metrics worksheet:

 

Contribution Margin ratio
Breakeven in sales dollars
DOL and DFL
Growth rate of Net Income
Cash Flows from Ops & Free Cash Flow
Year of Payback for your shark investor
IRR and NPV for your shark investor
(20 pts) Answer questions about your results on the Milestone 3 Questions tab.

RELATED: Frank Slade, sales manager for StopFast, a regional manufacturer of automotive brakes based out of Des Moines, Iowa, has been experiencing a difficult time filling an open sales rep position that was vacated by a rep who quickly left the company due to his spouse’s job transfer.

Order This Paper

Reviews

There are no reviews yet.

Be the first to review “[ORDER] MILESTONE 3: Analysis of Forecasted Financials (60 points)”

Your email address will not be published. Required fields are marked *

error: Content is protected !!