Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000, and the remainder is financed at (15) percent compounded semi-annually with semi-annual payments over 4 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows a) Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period. b) Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period. c) Plan 3: Make equal end-of-period payments.
Mortgages
A mortgage is a formal agreement in which a bank or other financial institution lends cash at interest in return for assuming the title to the debtor's property, on the condition that the obligation is paid in full.
Mortgage
The term "mortgage" is a type of loan that a borrower takes to maintain his house or any form of assets and he agrees to return the amount in a particular period of time to the lender usually in a series of regular equally monthly, quarterly, or half-yearly payments.
Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000, and the remainder is financed at (15) percent compounded semi-annually with semi-annual payments over 4 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows
a) Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.
b) Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period.
c) Plan 3: Make equal end-of-period payments.
d) Plan 4: Make a single payment of principal and interest at the end of the loan period.
e) A different plan: Pay off the principal in such a way that it is X, 1.5X, 2X, 2.5X... till the end of the last payment period. In addition, pay the accumulated interest at the end of each interest period.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
