BUS 173C
Five Year Financial Plan Case V1
The Company has raised the Series A round of financing as determined in the one-year plan. The Company has finished its first year (Year 1) and more capital needs to be raised. The three founders believe they can achieve more than $80m in revenue with a net profit of 17% by year 5. To raise capital, they need to pro forma Years 2-5 for their pitch deck. Year 1 data has been loaded in the template and is highlighted with orange cells. Yellow cells are input cells. (Caution: Due to the way the spreadsheet was constructed, there may be amounts in cells like Revenue that will change as soon as you put in your assumptions.) Using the 5-year template provided, pro forma the financial statements and determine the amount of capital the Series B investors should invest. Complete the template with your assumptions. See what the lowest cash balance is before determining how much cash needs to be invested by the Series B investors.
The following assumptions should be input:
Balance Sheet
Accounts receivable days outstanding is 2 months
Inventory days are 3 months
Accounts payable days deferred are 1 month
At no time can cash be lower than $5,000,000
Income Statement
Cost of Goods can’t be lower than 50% and 40% for Large and Medium
Everything else is up to you.
Grading:
Your pro forma plan will be peer reviewed for the following criteria:
1) Completed template
2) Reasonableness of the pro forma
a. Do the common income statements and YOY changes make sense?
b. Do the balance sheets move in a predictable manner for the growth rate?
c. Hint: You may want to look at other public medical device companies to see what is reasonable.
版权所有:编程辅导网 2021 All Rights Reserved 联系方式:QQ:99515681 微信:codinghelp 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。