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
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
Get step-by-step solutions from verified subject matter experts
