# What excell formula is used to determine APR when given present value and future value. It has to be determined for one year when compounded (1) semiannually and (2) monthly

Question
5 views

What excell formula is used to determine APR when given present value and future value. It has to be determined for one year when compounded (1) semiannually and (2) monthly

check_circle

Step 1

Step1: Calculating step of APR for a year when compounded semi-annually in excel. We have,

1. Calculating the monthly payment for the mortgage in the Excel. We have,

The Excel formula is as follows:

=PMT (Yearly Interest Rate/2, Duration of loan (Duration of loan x 2), Amount Borrowed)

1. Calculating the APR rate (semi-annually) fo...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in 