Use Excel if possible.
Problem 1) (Amortization Schedules - Straight Line) Spencer Company sells 10% bonds having a maturity value of $300,000,000 for $2,783,724. The bonds are dated January 1, 2012, and mature January 1, 2017. Interest is payable annually on January 1.
Problem 2) (Amortization Schedules - Effective-Interest) Assume the same information as #2 but in Effective Interest Method.