Question: Create Mountain Hazelnuts funding analysis spreadsheet . Use the template Download templateprovided. Consider the following: a. When building out the spreadsheet analysis, assume you have
Create Mountain Hazelnuts funding analysis spreadsheet. Use the template Download templateprovided.
Consider the following:
a. When building out the spreadsheet analysis, assume you have 4 different investors & divide up the cash flows from MH to optimize MH's value.
1. Investor is a socially conscious foundation willing to invest $2.5 million, happy to have no return but wants principal back within 3 years of investment.
2. Investor is a socially conscious investor willing to invest $10 million at an interest rate of 5% for 10 years.
3. Investor is a Venture investor willing to invest rest of funds needed for a 35% return on capital invested.
4. Investor is a local financial institution that will lend you up to $1 million at an interest rate of 3% for up to seven years.
All investors are willing to be paid with balloon payments of principal at the end of the loan, allow for no penalty pre-payments and want interest paid annually.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
