In: Accounting
Overall Instructions:
Prepare the report in good form as if you were submitting it to the financial vice-president of the company. It should be neat, well organized, and easy to follow. The standard is that anyone with accounting knowledge should be able to pick up your paper and quickly see what it accomplishes.
The spreadsheet should be programmed to make all calculations. For revisions, you should need only to type in the new information. Specific rules include:
Type each item of information only once.
Never embed information in formulas.
All information and solutions should be clearly labeled on excel.
Insole Vent Company purchased a building on January 1, 2026, paying $200,000 down and signing a mortgage note for an additional $3,400,000. The mortgage will be paid off with semi-annual payments (June 30 and December 31) over a period of 10 years. The mortgage rate is 4.5%.
Required:
Prepare the mortgage amortization schedule for the 10 years of this note.
Prepare the journal entries for the date of the sale and for the first two payments.
In a separate tab, repeat part A assuming the mortgage rate is 5%.
In a separate tab, repeat part A assuming the down payment of $500,000 and a mortgage of $5,000,000.
The formula to Caluclate EMI is as follows: P*R*((1+R)^N/((1+R)^N-1)
Where, P = Principal, R= Rate per period, N = Number of Monthly Installments
which in this case is P = $34,00,000, R = 4.5%/2, N= 20
Hence Putting this in the formulae = (3400000*4.5%/2*((1+4.5%/2)^20)/((1+4.5%/2)^20-1))
The EMI will come as = $212983.04.
The Mortgage amortization schedule has been attached:
The Journal Entries would be as follows -
For Purhase
1/1/2026 Building A/c Dr. $36,00,000
To Mortgage A/c $36,00,000
(Being Building Purchased on Mortgage)
MOrtgage A/c Dr. $2,00,000
To bank A/c $2,00,000
(Being Down payment made)
6/30/2026 Mortgage A/c Dr. $1,36,483.04
Interest A/c Dr. $76,500
To Bank A/c $2,12,983.04
(Being !st half yearly EMI paid)
12/31/2026 Mortgage A/c Dr. $1,39,553.91
Interest A/c Dr. $73,429.13
To Bank A/c $2,12,983.04
(Being 2nd Half-yearly EMI paid)
All the other Mortgage Amortisation schedules are attached.