1. Company A decides to purchase an additional warehouse to store their inventory. The warehouse costs $975,000. On 06/01/20 they purchase the facility and decide to put $150,000 down as a down payment and finance the rest through a bank. The bank decides they will loan it over 10 years at 7.5% interest (monthly payments), with the first payment due on 07/01/20. Please complete the following in a spreadsheet:

a. Calculate the monthly payments, using Excel's functions.

b. Create a loan amortization schedule for the first two years in Excel using formulas.

c. Assuming Company A adjusts for accrued interest at the end of every month, what amount of accrued interest will they adjust for at 12/31/20? Clearly indicate your answer on Excel by shading the entire box yellow and labeling it.

d. Please calculate the current portion of this loan as of 12/31/20. Clearly indicate your answer on Excel by shading the entire box yellow and labeling it.

1. Company A decides to purchase an additional warehouse to store their inventory. The warehouse costs $975,000. On 06/01/20 they purchase the facility and decide to put $150,000 down as a down payment and finance the rest through a bank. The bank decides they will loan it over 10 years at 7.5% interest (monthly payments), with the first payment due on 07/01/20. Please complete the following in a spreadsheet: a. Calculate the monthly payments, using Excel's functions. b. Create a loan amortization schedule for the first two years in Excel using formulas. c. Assuming Company A adjusts for accrued interest at the end of every month, what amount of accrued interest will they adjust for at 12/31/20 ? Clearly indicate your answer on Excel by shading the entire box yellow and labeling it. d. Please calculate the current portion of this loan as of 12/31/20. Clearly indicate your answer on Excel by shading the entire box yellow and labeling it