Homework Help is Here – Start Your Trial Now!
Business
Finance
Autosav e EX19_48_AISetouMagassouba lome Insert Draw Page Layout Formulas Data Review View Tell me 2 Share O Comments 201C fx JA O Define Name v E, Trace Precedents Q el v **. 2 Use in Formula v a Trace Dependents AutoSum Recently Financial Logical Used Show E Remove Arrows v Formulas Checking Window Calculation Options Insert Text Date & Lookup & Math & Time More Functions Name Error Watch unction Reference Trig Manager Create from Selection al_Int. : x v fx 1941 B C D F L A H J K N New Office Building Loan Calculator 8 Years $ (920,000) Scenarios Loan Payment Calculator 9/15/21 Rate Renovation 20 Years 4.45% 180 Date Property Price Down Payment Loan Amount $1,020,000 4.45% Loan Amount Charles Street Term in Months Annual Interest Rate 4.25% 0.37% 15 0.35% 20 4.45% 0.37% 8 $7,014.45 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date 180 1/3/22 240 96 1/3/22 1/3/22 2 PM Varying Interest Rates and Terms (6,000) $ Monthly Payment Future Value (8,000) Rate Number of Months n/a n/a 120 180 240 3.95% 4.05% 4.15% t 1 PM 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% t ot 5.15% 5PM ot M Documentation Loan Calculator Properties Equipment Loan Ready 囲 100% ude Special_Programs_ Enelieh (United Ctetteel Ce eue 1908

Autosav e EX19_48_AISetouMagassouba lome Insert Draw Page Layout Formulas Data Review View Tell me 2 Share O Comments 201C fx JA O Define Name v E, Trace Precedents Q el v **. 2 Use in Formula v a Trace Dependents AutoSum Recently Financial Logical Used Show E Remove Arrows v Formulas Checking Window Calculation Options Insert Text Date & Lookup & Math & Time More Functions Name Error Watch unction Reference Trig Manager Create from Selection al_Int. : x v fx 1941 B C D F L A H J K N New Office Building Loan Calculator 8 Years $ (920,000) Scenarios Loan Payment Calculator 9/15/21 Rate Renovation 20 Years 4.45% 180 Date Property Price Down Payment Loan Amount $1,020,000 4.45% Loan Amount Charles Street Term in Months Annual Interest Rate 4.25% 0.37% 15 0.35% 20 4.45% 0.37% 8 $7,014.45 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date 180 1/3/22 240 96 1/3/22 1/3/22 2 PM Varying Interest Rates and Terms (6,000) $ Monthly Payment Future Value (8,000) Rate Number of Months n/a n/a 120 180 240 3.95% 4.05% 4.15% t 1 PM 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% t ot 5.15% 5PM ot M Documentation Loan Calculator Properties Equipment Loan Ready 囲 100% ude Special_Programs_ Enelieh (United Ctetteel Ce eue 1908

Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
See similar textbooks
icon
Related questions
Question
  1. Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:

a) For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods.

b)For the pv argument, use the Loan_Amount (cell B8) to include the present value.

c)Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount.

AutoSave a SC_EX19_4a_AisetouMagassouba_1 OFF Home Insert Draw Page Layout Formulas Data Review View O Tell me Share O Comments 2010 fx I Define Name v Trace Precedents ... Use in Formula v Trace Dependents AutoSum Recently Financial Logical Used Lookup & Math & Reference Watch Date & Time Insert Тext More Name Show Error Calculation Function Trig Functions Manager Create from Selection Remove Arrows v Formulas Checking Window Options Total_Int.. fx 1941 A D E F G H J K M N 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator Scenarios Renovation 20 Years 8 Years $ 1,020,000 4 Date 5 Property 6 Price 7 Down Payment 8 Loan Amount 9/15/21 Rate 4.45% Loan Amount 2$ (920,000) Charles Street Term in Months 180 Annual Interest Rate 4.45% 4.25% 4.45% 2$ 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost $7,014.45 Month ly Interest Rate Loan Period in Years 0.37% 0.35% 0.37% 15 20 8 2$ Loan Period in Months 180 240 96 9 Start Date 1/3/22 1/3/22 1/3/22 2 PM 2$ Monthly Payment Future Value 10 Varying Interest Rates and Terms (6,000) $ (8,000) 11 Rate Number of Months n/a n/a 12 120 180 240 3.95% 14 4.05% 15 4.15% 16 4.25% it 17 4.35% 1 PM 18 4.45% 19 4.55% 20 4.65% 21 4.75% 22 4.85% 23 4.95% 24 5.05% t 25 5.15% Б РМ 26 27 28 29 30 31 ot 32 33 34 Documentation Loan Calculator Properties Equipment Loan %3D Ready + 100% Special_Programs_ Transfer...est copy 28 words English (United States) Focus + 180% 2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM 111 11
Transcribed Image Text:AutoSave a SC_EX19_4a_AisetouMagassouba_1 OFF Home Insert Draw Page Layout Formulas Data Review View O Tell me Share O Comments 2010 fx I Define Name v Trace Precedents ... Use in Formula v Trace Dependents AutoSum Recently Financial Logical Used Lookup & Math & Reference Watch Date & Time Insert Тext More Name Show Error Calculation Function Trig Functions Manager Create from Selection Remove Arrows v Formulas Checking Window Options Total_Int.. fx 1941 A D E F G H J K M N 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator Scenarios Renovation 20 Years 8 Years $ 1,020,000 4 Date 5 Property 6 Price 7 Down Payment 8 Loan Amount 9/15/21 Rate 4.45% Loan Amount 2$ (920,000) Charles Street Term in Months 180 Annual Interest Rate 4.45% 4.25% 4.45% 2$ 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost $7,014.45 Month ly Interest Rate Loan Period in Years 0.37% 0.35% 0.37% 15 20 8 2$ Loan Period in Months 180 240 96 9 Start Date 1/3/22 1/3/22 1/3/22 2 PM 2$ Monthly Payment Future Value 10 Varying Interest Rates and Terms (6,000) $ (8,000) 11 Rate Number of Months n/a n/a 12 120 180 240 3.95% 14 4.05% 15 4.15% 16 4.25% it 17 4.35% 1 PM 18 4.45% 19 4.55% 20 4.65% 21 4.75% 22 4.85% 23 4.95% 24 5.05% t 25 5.15% Б РМ 26 27 28 29 30 31 ot 32 33 34 Documentation Loan Calculator Properties Equipment Loan %3D Ready + 100% Special_Programs_ Transfer...est copy 28 words English (United States) Focus + 180% 2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM 111 11
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS