View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul 022 Paul 022 is offline
external usenet poster
 
Posts: 1
Default Financial function - calculating loans with deferred payments

Anyone know of a way to calculate the repayment schedule for a loan with
fixed interest rate and term, and a deferred payment schedule? For example,
figuring the payments on a 40-year loan for the amount of $10 million at 6%,
if the payments were only made in years 26 through 40. Functions in Excel,
from what I see, require payments to begin in year 1. I can use the NPV
function to try to get in the ballpark, but that's a slow, interative process.

Thanks for the help.