Hi, I'm familiar with the RATE function both using a standard loan profile, or running an amortisation table with multiple cash flows. However, is there a simple way to calculate/solve the RATE for a profile such as this:
6 x $100 followed 30 x $374.25, monthly in arrears for a loan of $10,000 (which I know is 10% IRR/Nominal) without having to create the table?
Thanks in advance for your suggestions.
6 x $100 followed 30 x $374.25, monthly in arrears for a loan of $10,000 (which I know is 10% IRR/Nominal) without having to create the table?
Thanks in advance for your suggestions.
