Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create the spreadsheet models shown in the following figure below Figure 1 using the formula shown for appropriate cells in MS Excel. table [

Create the spreadsheet models shown in the following figure below Figure 1 using the formula shown for appropriate cells in MS Excel.
\table[[,A,B,C,D,E,F,G,H,I,J,K],[1,Simple Loan Calculation Model in Excel],[2,,,,,,,,,,,],[3,Loan Amount,$150,000,,,,,,,,,],[4,Interest Rate,8.00%,,,,,,,,,],[5,Numer of Years,30,,,,,,,,,],[6,,,,,,,,,],[7,Number of Months,360,,=B5**12,,,,,,,],[8,Interest Rate/Month,0.67%,larr,=B412,,,,,,,],[9,,,,,,,,,],[10,Monthly Loan Payment,($1,100.65),larr,=PMT(B8,B7,B3,0),,,,,],[11,,,,,,,,,],[12,,,,,,,,,],[13,(NB: PMT funct,ion calcul,ates the payr,ent for a l,an be,n cor,tpay,and,stant,est rate)],[14,,,,,,,,,,]]
Fig. 1
a. What is the effect on Monthly Loan Payment of a change in the interest rate from 8% to 10% in the spreadsheet model shown in Figure 1?
b. For the original model in Figure 1(at 8% interest), what would be the Monthly Loan Payment if the Number of Years for payment is 15?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Working Capital Management And Finance A HandBook For Bankers And Finance Managers

Authors: R.K.Gupta, Himanshu Gupta

4th Edition

1645875547, 9781645875543

More Books

Students also viewed these Finance questions

Question

Evaluate employees readiness for training. page 275

Answered: 1 week ago