![]() is a contractual agreement in which money is borrowed from a lender and paid back over a specific period of time. However, before demonstrating this function, it is important to cover a few fundamental concepts on loans and leases.Ī loan A contractual agreement in which money is borrowed from a lender and paid back over a specific period of time. This function calculates the payments required for a loan or a lease. One of the functions we will add to the Personal Budget workbook is the PMT function. This section also discusses the scenario capabilities of Excel once the Personal Budget workbook is complete. This section demonstrates Excel functions used to calculate lease payments for a car, to calculate mortgage payments for a house, and to project future savings based on regular contributions and an average rate of return. In addition, you may want to set and track a savings goal. ![]() ![]() Notable items that are missing from the Budget Detail worksheet are the payments you might make for a car or a home. In this section, we continue to develop the Personal Budget workbook.
0 Comments
Leave a Reply. |