Read the written case, Metastasis Magnetics Corp. Download Metastasis Magnetics Corp.and apply the case information to the financial planning model template, BUS 170 Metastasis Magnetics Corp financial template. Download BUS 170 Metastasis Magnetics Corp financial template. The point allocation for completing the plan is as follows:

1) Using the template left behind by the temp CFO, finish the 12-month plan. (10 pts)

2) Also, pro forma the post money capital schedule based on the Series A terms offered. (2 pts)

Q1) In rounded millions, how much combined debt and equity needs to be raised to avoid running out of cash in the first year? (2 pts)

Q2) What is post money combined ownership percentage of the three founders after the Series A? (2 pts)

Q3) If there no other changes in the capital structure and the Series A investors have a required return of 50% in 5 years, what will the value of the company be in year 5? (2 pts)

Q4) Using sensitivity analysis, which of the following variables will have the greatest impact on cash? Show proof of your position (2 pts)

a) Price per unit of H1/D1

b) DSO

c) Engineering salaries

d) Debt/equity ratio