Create an amortization schedule, using Excel, for the following loan.

Principal: $100,000

Interest: 6%

Duration: 10 years

Frequency of interest and payment: monthly

The table should have the following column headings:

Year # | Beginning Balance | Year Pmt. | Interest Paid | Principal Paid | End Balance

This must be done in Excel and the Excel sheet e-mailed to me by 11:59 P.M. on Friday, Oct. 1.

Suggestion: Look up how to enter formulae into Excel and how to drag and fill

(can the answer be the link to the excel sheet) thanks