Calculating APR ? Any suggestions?

zacemmel

Well-known Member
Joined
Apr 29, 2002
Messages
636
I am trying to calculate the APR on a loan based on the fact that there are certain costs. I don't fully understand APR and I was wondering if there are any built-in functions to calculate the "costs" that are to be included with the LOAN?

Any financial wizards in the house?

IE, I have a loan of $100,000 and I have costs of $4,200 -

Any help would be greatly appreciated.

Thanks.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
One more thing, the interest rate would be 6% and the payments would be monthly. Term would be 30 years.
 
Upvote 0
If costs are deducted at the beginning,
calculate the payments on the gross amount.

Then use the function RATE considering the calculated payment, net proceeds, and other factors.

See Help on Rate
 
Upvote 0
A B C
1 Loan % Rate 6.00%
2 Loan Amount $100,000.00
3 Cost $4,200.00
4 Total Loan $104,200.00 =SUM(B2:B3)
5 Periods 360
6 Mo Payment ($624.73) =PMT(B1/12,B5,B4,0)
7 APR 6.39% =RATE(B5,B6,B2)*12
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top