Having a lot of trouble with excel, I don't understand it at all and is asking for some help. It would be much appreciated !
the question is:
Your company is planning on purchasing a new stadium using a loan. The stadium price is $2,500,000 and
they plan to put $275,000 as a down payment. They have arranged to pay the loan off over 10 years using
monthly payments due at the beginning of the month. The Bank of America is ready to offer them a loan at
an APR of 3.75%
1.In the worksheet called “Data Tables,” use the information above to fill in cells C3:C7, and
C10:C12.
2. Use PMT, CUMPRINC and CUMIPMT financial functions to fill in cells C12:C14. Have the
latter three cells display as positive numbers in “Accounting” format with two decimal places.
3. You are curious to see what would happen if interest rates rise on this purchase. Construct a onevariable
data table in the range E4:H19. In the E5:E19 column, use Autofill to increase the annual
interest rate in 0.25% increments, starting at 3.5% in cell E5. (i.e., 3.5% to 3.75% to 4.00% and
so forth) and display in “Percent” format with 2 decimal places.
Note: Excel 2013 may automatically place the formatting mentioned in the following steps. Make
sure the formatting is as specified.
4. Reference C13:C15 in cells F4:H4 and format them to display “Monthly Payment”, “Total to
Repay Loan” and “Total Interest Paid”. Adjust column widths so the full titles are visible.
5. Fill in the one-variable data table and format F5:F19 using the blue gradient fill data bar. Do the
same for G5:G19 and H5:H19 using the yellow and red gradient fill data bars respectively.
Format all these values to display in “Accounting” format with no decimal places.
If anyone is an expert and can help me ...
the question is:
Your company is planning on purchasing a new stadium using a loan. The stadium price is $2,500,000 and
they plan to put $275,000 as a down payment. They have arranged to pay the loan off over 10 years using
monthly payments due at the beginning of the month. The Bank of America is ready to offer them a loan at
an APR of 3.75%
1.In the worksheet called “Data Tables,” use the information above to fill in cells C3:C7, and
C10:C12.
2. Use PMT, CUMPRINC and CUMIPMT financial functions to fill in cells C12:C14. Have the
latter three cells display as positive numbers in “Accounting” format with two decimal places.
3. You are curious to see what would happen if interest rates rise on this purchase. Construct a onevariable
data table in the range E4:H19. In the E5:E19 column, use Autofill to increase the annual
interest rate in 0.25% increments, starting at 3.5% in cell E5. (i.e., 3.5% to 3.75% to 4.00% and
so forth) and display in “Percent” format with 2 decimal places.
Note: Excel 2013 may automatically place the formatting mentioned in the following steps. Make
sure the formatting is as specified.
4. Reference C13:C15 in cells F4:H4 and format them to display “Monthly Payment”, “Total to
Repay Loan” and “Total Interest Paid”. Adjust column widths so the full titles are visible.
5. Fill in the one-variable data table and format F5:F19 using the blue gradient fill data bar. Do the
same for G5:G19 and H5:H19 using the yellow and red gradient fill data bars respectively.
Format all these values to display in “Accounting” format with no decimal places.
If anyone is an expert and can help me ...
Last edited by a moderator:
