interest rate

How would I determine the interest rate on a loan with an initial deferral period? Example: PV: $105,905 N: 24 (maybe 27?) Pmt: Months 1-3 at $0, Months 4-27 $4,626 FV: $0 Using T-Value, I get a rate of 3.67%, but I can't mimic it in Excel.

The function PMT is very helpful in creating an amortization table. The problem with PMT is that it assumes that payments are made at the same time every month. I am trying to create an amortization table that accounts for early or late payments and adjusts the interest amount accordingly...

I am attempting to bulid a formula that will determine rate on an "end of the period" loan where the only knowns are: Starting Balance Term and frequency of payments Number of payments made Current Balance For example: On a $100,000 30yr mortgage, 12 payments have been made, and the current...

<tbody> Loan amount £400.00 Term in months 9 Total payable £446.02 APR 26.8242% Amount of repayments (9 monthly payments) £49.56 Annual fixed rate of interest </tbody> Hello I have attached an excel sheet with the information I have about a loan. Excuse my ignorance, but...

Hi there. I need create a spreadsheet that calculates based on a monthly interest rate. I have the principal amount, the rate (1.5% per month) but I'm having difficulty trying to formulate the time. This is the formula I'm using on my spreadsheet: I= PxRxT But I can't figure out how to...

I'd like to write my own functions to calculate effective yield based on either 30/360 or actual/actual, but the yield function is not what I'm looking for. My known variables are average balance and YTD interest. For the 30/360 function I would divide by the number of months and multiply by...