Question 1

Use 2 separate tabs for these 2 questions.

1. Build a loan amortization schedule using goal seek. The info of the loan:

. Amount of the loan: $500,000

Length of the loan: 15 years

Interest rate: 2% for the first 5 years, and 2.5% for the rest of the 10 years.

Payment: Fixed annual payment.

Set up your input section, so that your model is flexible and will update automatically with any changes to the inputs.

2. You are planning to open a small restaurant on Fowler Ave. featuring authentic Cuban food. You would like to do a capital budgeti opportunity. Here are your main projections of this restaurant, assuming you will run the restaurant for 10 years:

To start up, you have to invest $200,000 for your fixed assets.

Revenue in first year is $250,000, and should grow by 2.5% per year.

Rent of the storefront costs $36,000 per year, and should grow by 1% per year.

Employee salaries cost $80,000 per year.

Utilities cost $5,000 per year.

COGS (food supplies, kitchen equipment, silvers, etc) cost $45,000 per year.

Depreciation is $9,000 per year.

After 10 years in business, you plan to leave the business and sell your assets. The estimated selling value for all your fixed assets