Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(0) A B C D E F 1 Frequency : Monthly 2 Loan Amount: 150000.00 3 Interest Rate: 7.25% 4 Term(years): 30.00 5 No. of
(0)
| A | B | C | D | E | F | |
| 1 | Frequency : | Monthly | ||||
| 2 | Loan Amount: | 150000.00 | ||||
| 3 | Interest Rate: | 7.25% | ||||
| 4 | Term(years): | 30.00 | ||||
| 5 | No. of payments in a year: | 12 | time(s) | |||
| 6 | Periodic Rate: | 0.60% | =C3/C5 | |||
| 7 | Total number of payment: | 360 | =C4*C5 | |||
| 8 | Periodic payment: | 1023.26 | =-PMT(C6,C7,C2) | |||
| 12 | Payment period | Opening Principal | Installment | principal Payment | Interest Payment | Closing principal |
| 13 | 0 | - | - | - | - | 150000.00 |
| 14 | 1 | 150000.00 | 1023.26 | 117.01 | 906.25 | 149882.99 |
| 15 | 2 | 149882.99 | 1023.26 | 117.72 | 905.54 | 149765.26 |
| 16 | 3 | 149765.26 | 1023.26 | 118.43 | 904.83 | 149646.83 |
Using the data above please answer question 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Management Principles And Applications
Authors: J William Petty, Sheridan Titman, Arthur J Keown, John D Martin, Peter Martin, Michael Burrow, Hoa Nguyen
6th Edition
1442539178, 9781442539174
