![]() However, you can make Excel do the work for you by using the What-If Analysis Goal Seek tool. Many people in this situation would simply start typing numbers in cell A2 until the figure in D2 reached approximately $6,000. ![]() You are now wondering what is the highest interest rate you can take on for the loan to make sure you don’t end up paying more than $6,000 per year. Suppose you do some figuring and find out that you can afford to pay back $6,000 per year in mortgage payments. Unfortunately, no mortgage lender is going to lend you $100,000 at 0% interest. Notice that the figure in D2 is negative since Excel assumes that the payments are a negative cash flow from your financial position. And represents the yearly payments of a 30-year, $100,000 mortgage at 0% interest.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |