Question

You are the new controller for Moonlight Bay Resorts. The company CFO has asked you to determine the company’s interest expense for the year ended December 31, 2018. Your accounting group provided you the following information on the company's debt: (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

1. On July 1, 2018, Moonlight Bay issued bonds with a face amount of $2,500,000. The bonds mature in 20 years and interest of 9% is payable semiannually on June 30 and December 31. The bonds were issued at a price to yield investors 10%. Moonlight Bay records interest at the effective rate.
2. At December 31, 2017, Moonlight Bay had a 10% installment note payable to Third Mercantile Bank with a balance of $550,000. The annual payment is $85,000, payable each June 30.
3. On January 1, 2018, Moonlight Bay leased a building under a finance lease calling for four annual lease payments of $50,000 beginning January 1, 2018. Moonlight Bay’s incremental borrowing rate on the date of the lease was 13% and the lessor’s implicit rate, which was known by Moonlight Bay, was 12%.

Required:
Calculate interest expense for the year ended December 31, 2018. (Round your answer to nearest whole dollar.)

Answer 1

Total Interest Expense		$        1,82,186.61
Working:
Interest expense on Bonds:
Interest Payment ($2500,000 * 9%/2)	$               1,12,500.00
Interest Rate (10%/2)	5%
NPER (2*20)	40
Price of Bonds (=pv(5%,40,112500,2500000,0))	$             22,85,511.42
Interest expense =2285511.42*5%		$        1,14,275.57
Interest expense on installment note:
Interest expense for 6 months( 550000*10%*1/2)	$                  27,500.00
Interest expense for next 6 months ((550000-(85000-27500-27500))*10%*1/2)	$                  26,000.00
Total interest expense on note		$           53,500.00
Interest expense on lease:
Present value of lease payments (50000*PVAF @12% for 4, 3.4018)= $170092	$                              1,70,092
Interest on lease = (170092-50000)*12%	$                  14,411.04
Total Interest Expense		$           14,411.04