代做BUS 173C Five Year Financial Plan Case V1帮做R程序

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.