Question: Please answer using an Excel file amd show cell formulas if possible. Four problems are provided below. You must set up an Excel worksheet to

Please answer using an Excel file amd show cell formulas if possible. Please answer using an Excel file amd show cell formulas if possible.

Four problems are provided below. You must set up an Excel worksheet to complete each problem. Please keep all of your work in a single Excel workbook (file) for submission, and name the tabs Problem 1, Problem 2, Problem 3, and Problem 4. Remember that formulas should only contain cell references (not numbers). Please leave your spreadsheet unprotected because / may want to change the number to make sure everything is working correctly. Remember that the spreadsheet you submit must be your own work. 1. (4 points) You plan to retire in 30 years and you are investing $250 per month in the BMO Large-Cap Growth mutual fund. The fund has an average annual return of 13.45%. How much will you have at retirement? (4 points) 2. (4 points) You have decided to start your own bakery. Starting up the new business will require funding for store fixtures, ovens, mixers, refrigerators, and supplies. You have some money to invest in the business, but you don't have enough to fund everything. So, you have decided to go to the bank to ask for a loan. After looking at your revenue and expense projections, you have determined that you can make monthly loan payments of $1,425 on a ten-year loan. The interest rate on commercial loans is 8.50 percent. How much will the bank be willing to lend? (4 points) 3. (4 points) Upon retirement, you want to have enough money to provide an income of $5,000 per month for 35 years. Given a return of 8.0%, how much money will you need at retirement? 4. (8 points) You recently purchased a car and financed the purchase with a $12,000 loan. The interest rate on the loan is 6.25% and you will be making monthly payments for 4 years. a. Calculate the monthly loan payment. b. Develop an amortization schedule for the loan

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!