Greely Corporation is a publicly-traded corporation with a calendar year end. For purposes of classifying current assets and current liabilities, it uses a one year period.

1. On January 1, 2016, Greeley Corporation borrowed $1,500,000 cash from First Source Bank by signing a three-year note bearing 4% interest. The bank requires equal annual payments on January 1st of each year. The first payment was due on January 1, 2017.

2. On March 15, 2016, Greeley Corporation borrowed $750,000 cash from JP Morgan Chase Bank by signing a four-year note bearing 3.75% interest. The bank requires equal monthly payments on the 15th of each month. The first payment was due on April 15, 2016.

3. On June 1, 2016, WTM Corporation borrowed $500,000 cash from Fifth Third Bank by signing a two-year note bearing 3.25% interest. The bank requires bi-monthly payments on the 1st and 15th of each month. The first payment is due on June 15, 2016.

4. On October 1, 2016, WTM Corporation issued an eighteen-month zero-interest bearing note for $200,000 note to Lake City Bank and received $189,223. WTM amortizes the discount at the end of each month using the effective interest rate method.

Required:

1. Compute the required payments for the notes to First Source, JP Morgan Chase, and Fifth Third Bank using Excels PMT function.

2. Compute the interest rate on the note to Lake City Bank using Excels RATE function.

3. Construct amortization tables for each of the four notes for the entire term of the loans. Provide labels for the dates of the payment, the payment, interest expense, principal reduction, and book value of the debt.

4. Complete a partial balance sheet for Greeley Corporation for December 31, 2016 and December 31, 2017.

7. Prepare the Cash Flow from Financing Activities section of the Statement of Cash Flows for Greeley Corporation for 2016 and 2017, assuming that the only debt issued during the year was the borrowing from First Source Bank.