- In cell G10, insert a formula using the
PMT
function using the monthly interest rate (cell
G6), the loan period in months (cell
G8), and the loan amount (cell
G4) to calculate the monthly payment for the 10 Years scenario.
Extracted text: SC EX19_CS4-7a_AlexisDonald_2 - P Search 困 AutoSave Off Alexis Donald AD File Home Insert Page Layout Formulas Data Review View Help Team A Share P Comments From Text/csV A Recent Sources E Queries & Connections Clear 組Flash Fill S- Consolidate From Web B Existing Connections E Properties EReapply Filter E Remove Duplicates Relationships Get Refresh Stocks Currencies Geography Sort Text to What-If Forecast Group Ungroup Subtotal Automatic Anatomy Data v E From Table/Range All- a Edit Links EAdvanced Columns co Data Validation v 8 Manage Data Model Analysis v Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline G10 A В D E G H J K M N P Q R 1 Business Expansion 2 Loan Calculator 3 Loan Payment Calculator Scenarios 10 Years 15 Years 5 Years 4 Date 10/12/2021 Rate 4.35% Loan Amount 1,720,000 $ 1,720,000 5 Purchase Distribution center Term in Months 180 Annual Interest Rate 4.45% 4.40% 4.55% 2,150,000 Monthly Payment 430,000 Total Interest 1,720,000 Total Cost $13,026.41 Monthly Interest Rate Loan Period in Years Loan Period in Months 6 Price 0.37% 0.37% 0.38% 7 Down Payment $ 624,753.96 $2,774,753.96 10 15 5 Loan Amount 120 180 60 9 Start Date 1/3/2022 1/3/2022 1/3/2022 10 Varying Interest Rates and Terms Monthly Payment $ (16,000) $ (20,000) 11 Rate Number of Months Future Value n/a n/a 12 $ 13,026 120 180 240 13 3.85% 17,291.81 $ 12,593.73 $ 10,287.42 Candidate Properties 17,373.32 $ 17,455.07 $ 14 3.95% 12,679.58 $ 10,377.60 Туре Contact State Months on Mkt 15 4.05% 12,765.77 $ 10,468.23 16 4.15% 17,537.04 $ 12,852.31 $ 12,939.19 $ 13,026.41 $ 13,113.97 $ 13,201.88 10,559.31 17 4.25% 17,619.26 $ 10,650.83 18 4.35% 17,701.70 $ 10,742.80 19 4.45% 17,784.38 $ 10,835.20 20 4.55% 17,867.29 $ 10,928.05 21 4.65% 17,950.44 Ş 13,290.12 11,021.33 13,378.71 $ 18,033.81 $ 18,117.42 $ 18,201.26 $ 18,285.33 $ 22 4.75% 11,115.05 23 4.85% 13,467.63 11,209.20 24 4.95% 13,556.89 $ 11,303.78 25 5.05% 13,646.49 $ 11,398.80 26 27 28 29 30 31 32 33 34 Documentation U.S. Canada U.K. All Locations Original Content Subtotals Expansion Funding Ready 田 100% 6:45 PM O Type here to search 73°F Sunny 11/1/2021 20