, , , , , ,

[SOLVED] BUS 173C Five Year Financial Plan Case V1

$25

File Name: BUS_173C_Five_Year_Financial_Plan_Case_V1.zip
File Size: 386.22 KB

5/5 - (1 vote)

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.

 

 

 

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
[SOLVED] BUS 173C Five Year Financial Plan Case V1[SOLVED] BUS 173C Five Year Financial Plan Case V1
$25