A company borrowed money from a local bank. The note the company signed requires five annual installment payments of $12,000 not due for four years. The interest rate on the note is 7%. What amount did the company borrow? Amount of each installment payment $12,000 Interest rate 7% Number of installment payments 5 Not due for 4 years Amount borrowed Formula must include the =PV function and return a POSITIVE value
Added by James R.
Close
Step 1
The future value of the installment payments can be calculated using the formula: FV = P * (1 + r)^n Where: FV = Future value of the installment payments P = Amount of each installment payment ($12,000) r = Interest rate (7% or 0.07) n = Number of installment Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 95 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Supreeta N.
In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount in cell B4 * the number of payments in cell B2). Use cell references. In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments in cell B6 - the original price of the truck in cell B1). Use cell references. What is the process of this on the PVT? function? Thank you
Akash M.
3. You have just paid $1,135.90 for a bond, which has 10 years before it, matures. It pays interest every six months. If you require an 8% return from this bond, what is the coupon rate on this bond? Par value is $1000.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD