How to do pmt function in excel 2013

Finance Excel Helper

Documentation
Shelly Cashman Excel 2013
Chapter 4: SAM Project 1a
Flex Cab Company
FINANCIAL FORMULAS AND FORMATTING WORKSHEETS
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Capital Plan
Flex Cab Company
3-year Capital Plan
Amount Saved Monthly $ 6,500
Interest Earned Annually 2.5%
Term (years) 3
Accrued Savings $ 242,736
Loan Amount $ 500,000
Available Capital
Loan Scenarios
Flex Cab Company - Loan Scenarios
Aggressive Moderate Conservative
Loan Amount $ 500,000 $ 400,000 $ 300,000
Loan Term (yrs) 5 5 5
Loan Term (months) 60 60 60
Interest Rate (Annual) 5.00% 5.00% 5.00%
Monthly Interest Rate 0.42% 0.42% 0.42%
Monthly Payments by Interest Rate and Loan Scenario
AnnualRate MonthlyRate Aggressive Moderate Conservative
3.00% 0.25%
3.25% 0.27%
3.50% 0.29%
0.31%
0.33%
0.35%
0.38%
0.40%
0.42%
0.44%
0.46%
0.48%
0.50%
0.52%
0.54%
0.56%
Savings Scenarios
Flex Cab Savings Scenarios
Aggressive Moderate Conservative
Monthly Savings Amount $ 7,500 $ 6,500 $ 5,500
Term (Months) 36 36 36
Interest (Monthly) 0.21% 0.21% 0.21%
Accrued Savings
Accrued Savings by Monthly Savings and Interest Earned
Interest Rate Earned Monthly Savings Amount
Annual Monthly $ 7,500 $ 6,500 $ 5,500
1.00% 0.08% $273,975 $237,445 $200,915
1.25% 0.10% $274,980 $238,316 $201,652
1.50% 0.13% $275,991 $239,192 $202,393
1.75% 0.15% $277,006 $240,072 $203,138
2.00% 0.17% $278,026 $240,956 $203,886
2.25% 0.19% $279,051 $241,844 $204,637
2.50% 0.21% $280,080 $242,736 $205,392
2.75% 0.23% $281,115 $243,633 $206,151
3.00% 0.25% $282,154 $244,534 $206,913
3.25% 0.27% $283,199 $245,439 $207,679
3.50% 0.29% $284,248 $246,348 $208,449
3.75% 0.31% $285,302 $247,262 $209,222
4.00% 0.33% $286,362 $248,180 $209,999
4.25% 0.35% $287,426 $249,103 $210,779
4.50% 0.38% $288,496 $250,030 $211,563