On the Loan worksheet in cell c9 enter PMT function to calculate the monthly payment for the Altamonte springs 2018 facilities l
oan. Ensure that the function returns a positive value and set the reference to cells B5 and B6 as absolute references.
1 answer:
Answer and Explanation:
First of all we should have to know about PMT
PMT
stands for payment .payment that you want to send and receive.It is used in financial calculators and equation. It is a payment that return the periodic payment for a loan.
From the given statement we have to calculate the PMT for this purpose .
let us consider example where we take loan amount and have some interest and then calculate it.
loan of amount = $6000.00
Interest rate = 4.20%
period per year=15
period = 60
then monthly payment = $ 111.40
Using Excel then we get the monthly payment in cell C9
as calculations has been shown in the excel.
where you can get function who returns a positive value.
You might be interested in
Answer:
The capacity of the disk is "40 GB".
Explanation:
Given value:
Cache memory is often used to speed up the runtime. It will enable us to improve performance unless we can store information, that is retrieved constantly in memory space.
- Hit Cache: when the Processor relates to representing database data, Cache Hit results.
- Miss Cache: when this Processor responds to a non-present cache data, this will trigger its miss of cache.
- It doesn't have to retrieve the Main Memory through secondary storage.