Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
PMT function

PMT function

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
  1. 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.
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
Transcribed Image 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Boolean Algebra and Digital Logics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS

Expert Answers to Latest Homework Questions

Q: Determine the x-y and n-t components of the 13.0 kip force F acting on the simply supported beam.…
Q: The slope of the 6.4 kN force F is specified as shown in the figure. Express F as a vector in terms…
Q: do fast step by step.
Q: For the first one, I've also tried 1.7E-9 and 1.77E-9. Neither is correct.
Q: The answers are not 1.77E-9 and 1.55E-5. Please help.
Q: Question 25: Calculate the percent ionization of the weak acid or base solutions to two significant…
Q: Question 23: Calculate the Ka or Kb of the weak acids or bases as asked. Report your answers to two…
Q: Please correct answer and don't use hand rating
Q: Do not use chatgpt
Q: Please correct answer and don't use hand rating
Q: 3. Some basic advice about graphing. a. Always use graph paper and a ruler. b. It is very important…
Q: 1. Introduction  2.1 discuss 4 fundemental principles of enterprise risk management :• risk…
Q: The water pressure acting on a masonry dam varies as shown. If the dam is 20 ft wide, determine the…
Q: The water pressure acting on a masonry dam varies asshown. If the dam is 20 ft wide, determine the…
Q: The water pressure acting on a masonry dam varies as shown. If the dam is 20 ft wide, determine the…
Q: Match each equation with its graph. (Do not use technology.) 5 y 3 F 10 g -3 1 3 5 (a) y = 5x g G…
Q: Do not use chatgpt
Q: Please correct answer and don't use hand rating
Q: One compelling piece of evidence for human evolution is the fossil record, particularly the…
Q: None
Q: kau.3 answer must be in table format or i will give down vote