Question
AutoSave Off H File Home e r - buad5707-m 1-novice-workbook (2) - Ex... Page Layout Formulas...
AutoSave Off H File Home e r - buad5707-m 1-novice-workbook (2) - Ex... Page Layout Formulas Data Review View Searc Help Insert J29 - X ✓ fx A B D E F G H I J K L M 2 3 4 Practice Prob. 6) The stock and bond markets have become a difficult for you to stomach without a strong antacid. Your billionaire son-in-law, who is a titan in the world of real estate finance, suggests that you might want to invest in real estate, particularly single family and multi-family dwellings. This makes sense to you and you decide to build a flexible model to answer financing questions. The PMT(rate,nper,pv) function in Excel is your focus since you are keenly aware of cash flow issues resulting from bank loans. It contains 3 arguments: Rate, Number of Periods (Term), and Present Value (Principal). The model is shown below with particular values. Create a Scroll Bar that controls the value of nper and locate it next to the nper value in the model. Make the lower limit 120 and the upper limit 480. Also, make the increment change 12 and the page change 60. Use 3% annual rate and 150,000 as pv. 13 15 16 By the way, what happens to the $ reduction in payments as the term of the loan becomes longer? Is the change what you expected? rate (annual)=1 nper (mns)= pv ($)= 3.00% 360 150000 27 28 Monthly $ outflow= 29 30
Answers
Formulas used
ДА B rate (annual) = nper (mns) pv ($) = 3.00% 120 1,50,000 $ 3.00% 180 1,50,000 3.00% 240 1,50,000 $ 3.00% 300 1,50,000 3.00% 360 1,50,000 $ 3.00% 420 1,50,000 3.00% 480 1,50,000 $ $ $ $ asoo's 2,501 $ 4,500 $ Monthly $ outflow = $ 4,633 $ 4,522 $ 4,504 $ 4,501 $ 4,500 $ 4,500 $ 4,500 When the term of loan gets longer, the monthly outflow gets reduceed.2 A B 0.03 rate (annual) = nper (mns) pv ($) = 120 0.03 =+C3+60 150000 0.03 =+D3+60 150000 0.03 =+E3+60 150000 0.03 =+F3+60 150000 0.03 =+G3+60 150000 0.03 =+H3+60 150000 150000 Monthly $ outflow = =PMT(C2,C3,-C4,0,0) =PMT(D2,D3,-D4,0,0) =PMT(E2,E3,-E4,0,0) =PMT(F2,F3,-F4,0,0) =PMT(G2, G3,-G4,0,0) =PMT(H2,H3,-H4,0,0) =PMT(12,13,-14,0,0)
Similar Solved Questions
1 answers
A. Light is incident at 45 degrees from air onto water of n = 1.333. Find...
A. Light is incident at 45 degrees from air onto water of n = 1.333. Find the angle of refraction and draw the exact diagram. B. Light is incident at 45 degrees from air onto oil of n=1.200 and then passes into water of n=1.333. Find the angle in the oil and in the water. Draw the exact diagram. C. ...
1 answers
On January 1, 2017, Martinez Corporation granted 2,200 shares of restricted $5 par value common stock...
On January 1, 2017, Martinez Corporation granted 2,200 shares of restricted $5 par value common stock to executives. The market price (fair value) of the stock is $65 per share on the date of grant. The period of benefit is 2 years. Prepare Martinez’s journal entries for January 1, 2017, and ...
1 answers
20. For each transaction, identify which account is debited and which account is credited. Use proper...
20. For each transaction, identify which account is debited and which account is credited. Use proper account titles (Cash, Accounts Receivable, etc.). Debit Credit Transaction Received a bill for utilities to be paid next month Performed services on account Paid employees' salaries Paid cash fo...
1 answers
Intro BKM Industries spent $10,000 on a feasibility study to expand its production capacity. The company...
Intro BKM Industries spent $10,000 on a feasibility study to expand its production capacity. The company decided to go ahead with the expansion: It will need to buy a new machine for $51,000 and spend $8,000 on installing it. The machine will be depreciated linearly to zero over a 5-year period and ...
1 answers
10.4.8 Question Help In 1945, an organization asked 1414 randomly sampled American citizens, "Do you think...
10.4.8 Question Help In 1945, an organization asked 1414 randomly sampled American citizens, "Do you think we can devellop a way to profect ourselves from atomic bombs in case others tried to use them against us?" with 736 responding yes. Did a majority of the citizens feel the country could...
1 answers
Analyzing the Growth in Shareholders’ Equity (Easy) The following numbers were calculated from the financial statements...
Analyzing the Growth in Shareholders’ Equity (Easy) The following numbers were calculated from the financial statements for a firm for 2012 and 2011: (2012) (2011) Return on common equity (ROCE) 15.2% 13.3% Return on net operating assets (RNOA) 11.28% 12.75% Sales...
1 answers
Determine the values ofi (the interest rate per period), n (the number of interest periods), P...
Determine the values ofi (the interest rate per period), n (the number of interest periods), P (the present value), and F (the future value) for the following situation. A deposit of $500 invested at 27% interest compounded annually grows to 5556.23 in 4 years. i- n= (Type an integer or a decimal.) ...
1 answers
3. Determine the couple formed by the forces shown in the system (1 points+ 2 bonus...
3. Determine the couple formed by the forces shown in the system (1 points+ 2 bonus points) 5N IO N Sm ON B 5 N....
1 answers
9. Calculate the linear densities for the [100], [110] and [111] directions in a SC unit...
9. Calculate the linear densities for the [100], [110] and [111] directions in a SC unit cell. Which of these directions would be considered a close-packed direction (meaning most dense)?...
1 answers
Please help Which of the following accounts would show a balance in a post-closing trial balance?...
Please help Which of the following accounts would show a balance in a post-closing trial balance? Select one: O a. Dividends b. Rent Expense C. Sales Revenue d. Accumulated Depreciation e. None of the above X A major purpose of closing entries is to: Select one: o a. zero out the Retained Earnings...
1 answers
Barton Industries expects that its target capital structure for raising funds in the future for its...
Barton Industries expects that its target capital structure for raising funds in the future for its capital budget will consist of 40% debt, 5% preferred stock, and 55% common equity. Note that the firm's marginal tax rate is 25%. Assume that the firm's cost of debt, rd, is 9.2%, the firm...
1 answers
90) The motor end plate is A) the same as the neuromuscular junction. B) formed by...
90) The motor end plate is A) the same as the neuromuscular junction. B) formed by the membrane of enlarged axon terminals, or boutons, that lie on the surface of skeletal muscle cells. C) a special fibrous matrix whose collagen fibers hold the axon terminal in proper position. D) a folded area of m...
1 answers
The mechanical energy of a mass-spring system is 0.484 J. If the force constant of the...
The mechanical energy of a mass-spring system is 0.484 J. If the force constant of the spring of 330 N/m and the mass is 0.3 kg, what is the amplitude of the oscillatory motion in cm? Enter a number with one digit behind the decimal point...
1 answers
Internal Energy Chapter 11 two children sit on a seesaw each at a distance of 1.2...
Internal Energy Chapter 11 two children sit on a seesaw each at a distance of 1.2 m from the pivot point the mass of child 1 is 30 kg and the mass of child 2 is 20 kg, assume the mass of the seesaw itself is small. what is the net torque on the system of children plu seesaw, about the pivot point &#...
1 answers
Solve step by step Common Questions: Lab-4 A point P is 20 mm above the HP...
Solve step by step Common Questions: Lab-4 A point P is 20 mm above the HP and 30 mm in front of VP. Point Qis 45 mm below the HP and 35 mm behind the VP Draw the projections of P and Q keeping the distance between their projectors equal to 80 mm. Draw lines joining their top views and front views. ...
1 answers
Question 20 1 pts When people spend more years in school, this results in a externality because there are created by a...
Question 20 1 pts When people spend more years in school, this results in a externality because there are created by a more highly educated population. positive; external costs negative; internal costs O positive; internal benefits positive; external benefits negative; external costs Question 15 1 p...
1 answers
A charge q is placed at one of the corners of a cube of side a,...
A charge q is placed at one of the corners of a cube of side a, as shown below. Find the magnitude of the electric flux through the shaded face due to q. Assume q>0. We were unable to transcribe this image24 Answer 6...