| Solve for Ending Balance | | | Solve for Starting Balance/Maximum Loan Possible | | | Solve for Loan Payment | | | Solve for Rate | | | Solve for Number of Periods |
| Rate? | 0.25% | | Rate? | 0.33% | | Rate? | 0.43% | | Number of periods? (Months or Years) | 15 | | Rate? | 0.33% |
| Number of periods? (Months or Years) | 36 | | Number of periods? (Months or Years) | 180 | | Number of periods? (Months or Years) | 360 | | Payment? | $ - 0 | | Payment? | $ 473.00 |
| Payment? | $ 100.00 | | Payment? | $ - 0 | | Beginning Loan Value? | $ 500,000.00 | | Beginning Balance? | | | Beginning Balance? | $ 100,000.00 |
| Starting Balance? | $ 1,200.00 | | Ending Balance? | $ 192,000.00 | | Ending Balance? | $ - 0 | | Ending Balance? | $ 170,000.00 | | Ending Balance? | $ - 0 |
| Type? | Saving | | Type? | Loan | | | | | Type? | Loan | | Type? | Loan |
| Ending Balance | $5,074.92 | | Starting Balance | $105,477.02 | | Payment | $2,730.13 | | Payment | ERROR:#NUM! | | # Periods | 359.73 |
| This sheet works for COMPOUND INTEREST ONLY. Any problems using simple interest cannot be done on this Excel sheet.
You can only type in the Orange cells on this sheet |
p_patel359
Module2FormulaSheet.xlsx
