We explain how to calculate APR in Excel.You need to know all up front costs payable to the lender...build loan cash flows in Excel...calculate IRR.
vindeep.com