Microsoft KB Archive/50451: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 11: | Line 11: | ||
== SUMMARY == | == SUMMARY == | ||
To create a complete amortization schedule in Microsoft Excel that displays principal and interest payments, use the "LOAN3" sample on the Help & | To create a complete amortization schedule in Microsoft Excel that displays principal and interest payments, use the "LOAN3" sample on the Help & Examples Disk in the "Financial Analysis" folder within the "Sampler Files" folder. | ||
== MORE INFORMATION == | == MORE INFORMATION == | ||
Line 19: | Line 19: | ||
To extend the schedule to display the full standard 30-year schedule (360 payments), follow these instructions: | To extend the schedule to display the full standard 30-year schedule (360 payments), follow these instructions: | ||
# From the Options menu, choose Display and select Row & | # From the Options menu, choose Display and select Row & Column Headings. Click OK. | ||
# Change Term (years) to 30 in cell D7. (No. of Payments will automatically update to 360 in cell D11.) | # Change Term (years) to 30 in cell D7. (No. of Payments will automatically update to 360 in cell D11.) | ||
# Select cells B33 through B374 (an easy way to do this is to choose Goto from the Formula menu, type B33:B374 in the Reference box, and click OK). | # Select cells B33 through B374 (an easy way to do this is to choose Goto from the Formula menu, type B33:B374 in the Reference box, and click OK). | ||
Line 29: | Line 29: | ||
# Click "beginning_balance" and change D33 to D374, and click OK. | # Click "beginning_balance" and change D33 to D374, and click OK. | ||
# Select cells D33 through H374 and choose Fill Down from the Edit menu. | # Select cells D33 through H374 and choose Fill Down from the Edit menu. | ||
# From the Options menu, choose Display and deselect Row & | # From the Options menu, choose Display and deselect Row & Column Headings, if desired. | ||
|} | |} | ||
Latest revision as of 14:14, 21 July 2020
Excel: Amortization Schedule in Sample Documents, LOAN3Last reviewed: November 2, 1994 |
SUMMARYTo create a complete amortization schedule in Microsoft Excel that displays principal and interest payments, use the "LOAN3" sample on the Help & Examples Disk in the "Financial Analysis" folder within the "Sampler Files" folder. MORE INFORMATIONThe "LOAN3" sample is an example of a standard home mortgage amortization schedule for the first 18 periods (months). To extend the schedule to display the full standard 30-year schedule (360 payments), follow these instructions:
|
KBCategory: kbother Last reviewed: November 2, 1994 |