联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-21:00
  • 微信:codinghelp

您当前位置:首页 >> Matlab编程Matlab编程

日期:2025-03-14 01:50

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
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。 站长地图

python代写
微信客服:codinghelp