Part -1:
1. A beverage distribution company, Got Beverages, Inc. took out a 4-year $700,000 loan on January 1, 2016 to help finance their upcoming capital projects. The interest rate is 4% and they will make four annual installment payments that include interest and principal to repay the note. Got Beverages, Inc. has a year-end date of December 31.
Create the amortization schedule for this note in proper format. Label your spreadsheet cell that shows your TVM calculation for the note and be sure to link all cells properly for full credit.
Data:
pv
rate
nper
pmt?
2. Show ALL journal entries that Got Beverages should make over the four year life of the loan to record all transactions related to this note payable. Be sure to date your journal entries. You do not have to provide explanations for your journal entries. Link all cells for full credit.
Module 4 Assignment 1 Excel Workbook Assignment
Part -2:
1. A larger beverage distribution company, Got More Beverages, Inc. issued a 3-year bond with a $950,000 face value on July 1, 2016 to help finance their upcoming capital projects. The coupon rate is 4% and the market rate of interest is 4.5%. Interest will be paid semi-annually on June 30 and December 31 and the face value of the bond will be paid at maturity. Got More Beverages, Inc. has a year-end date of December 31. Create the amortization schedule for this bond in proper format. Label your spreadsheet cell that shows your TVM calculation for the bond, and be sure to properly link all cells for full credit.
2. Show ALL journal entries that Got More Beverages, Inc. should make over the three year life of the bond to record all transactions related to this bond payable. Be sure to date your journal entries. You do not have to provide explanations for your journal entries. Link all cells for full credit.