V C Update and complete this spreadsheet. Enter the appropriate values, functions or formulas in column B as indicated by the appropriate labels In column A and the information provided below. It should look "nice and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loan for 80% of this amount. The length of loan is seven years. You will be making one payment per month. The annual interest rate that is displayed in cell 88 will vary depending on the length of the loan in B7. Enter a function in cell B8 to indicate the interest rate based on the following: when the length is 5 years or less, the rate is 3.75% otherwise the rate is 4.25%. Complete the remaining cells in col B as indicated via the information in the column A headings as c as we have done in class and assignments. Create a table, as we did in class and assignments, that shows the changes in the "Total Monthly Income After Loan Payment when the Purchase Price varies from $75,000 to $100.000 by increments of $5000 and the length of loan in years varies from 5 to 10 in increments of one year. Use Goal Seek to change the "Total Amount Paid to Bank to $110,000 by adjusting the purchase price, (10 points) Excel File Edit View Insert Format Tools Data Window F AutoSave orr I Final - Savi Home Insert Draw Page Layout Formulas Data Review View TextBox 1 C D G Na S Purchase Price 6 Loan Amount 7 Length of loan in Years 8 Annual interest Rate 9 Payments/periods Per Year 10 11 Monthly Loan Payment 12 Total Amount Paid to Bank 13 Total interest Paid to Bank 14 15 Total Monthly income After Loan Payment 16 17 18 19 20 Update and complete this spreadsheet. Enter the ap as indicated by the appropriate labels in column Aam "nice" and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loa seven years. You will be making one payment per mon B8 will vary depending on the length of the loan in B7. rate based on the following: when the length is 5 year 4.25%. Complete the remaining cells in col B as indica as we have done in class and assignments. Final Sidont Draw Page Layout Formulas Data Review View Shape Format Tell me Share 3 c Update and complete this spreadsheet. Enter the appropriate values, functions or formulas in column B as indicated by the appropriate labels In column A and the information provided below. It should look "nice and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loan for 80% of this amount. The length of loan is seven years. You will be making one payment per month. The annual interest rate that is displayed in cell B8 will vary depending on the length of the loan in B7. Enter a function in cell B8 to indicate the interest rate based on the following: when the length is 5 years or less, the rate is 3.75% otherwise the rate is 4.25%. Complete the remaining cells in col B as indicated via the information in the column A headings as ih as we have done in class and assignments. Create a table, as we did in class and assignments, that shows the changes in the "Total Monthly income After Loan Payment when the Purchase Price varies from $75,000 to $100,000 by increments of S5000 and the length of loan in years varies from 5 to 10 in increments of one year Use Goal Seek to change the "Total Amount Paid to Bank to $110,000 by adjusting the purchase price. (10 points) Prob 1 Prob 2 V C Update and complete this spreadsheet. Enter the appropriate values, functions or formulas in column B as indicated by the appropriate labels In column A and the information provided below. It should look "nice and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loan for 80% of this amount. The length of loan is seven years. You will be making one payment per month. The annual interest rate that is displayed in cell 88 will vary depending on the length of the loan in B7. Enter a function in cell B8 to indicate the interest rate based on the following: when the length is 5 years or less, the rate is 3.75% otherwise the rate is 4.25%. Complete the remaining cells in col B as indicated via the information in the column A headings as c as we have done in class and assignments. Create a table, as we did in class and assignments, that shows the changes in the "Total Monthly Income After Loan Payment when the Purchase Price varies from $75,000 to $100.000 by increments of $5000 and the length of loan in years varies from 5 to 10 in increments of one year. Use Goal Seek to change the "Total Amount Paid to Bank to $110,000 by adjusting the purchase price, (10 points) Excel File Edit View Insert Format Tools Data Window F AutoSave orr I Final - Savi Home Insert Draw Page Layout Formulas Data Review View TextBox 1 C D G Na S Purchase Price 6 Loan Amount 7 Length of loan in Years 8 Annual interest Rate 9 Payments/periods Per Year 10 11 Monthly Loan Payment 12 Total Amount Paid to Bank 13 Total interest Paid to Bank 14 15 Total Monthly income After Loan Payment 16 17 18 19 20 Update and complete this spreadsheet. Enter the ap as indicated by the appropriate labels in column Aam "nice" and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loa seven years. You will be making one payment per mon B8 will vary depending on the length of the loan in B7. rate based on the following: when the length is 5 year 4.25%. Complete the remaining cells in col B as indica as we have done in class and assignments. Final Sidont Draw Page Layout Formulas Data Review View Shape Format Tell me Share 3 c Update and complete this spreadsheet. Enter the appropriate values, functions or formulas in column B as indicated by the appropriate labels In column A and the information provided below. It should look "nice and be formatted appropriately. Joe's monthly income is $8,250. You are buying a new RV for $85,000 and will get a loan for 80% of this amount. The length of loan is seven years. You will be making one payment per month. The annual interest rate that is displayed in cell B8 will vary depending on the length of the loan in B7. Enter a function in cell B8 to indicate the interest rate based on the following: when the length is 5 years or less, the rate is 3.75% otherwise the rate is 4.25%. Complete the remaining cells in col B as indicated via the information in the column A headings as ih as we have done in class and assignments. Create a table, as we did in class and assignments, that shows the changes in the "Total Monthly income After Loan Payment when the Purchase Price varies from $75,000 to $100,000 by increments of S5000 and the length of loan in years varies from 5 to 10 in increments of one year Use Goal Seek to change the "Total Amount Paid to Bank to $110,000 by adjusting the purchase price. (10 points) Prob 1 Prob 2