Calculate the rate per period in cell H9. All mortgages being financed will be paid monthly. After
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the rate per period in cell H9. All mortgages being financed will be paid monthly. After completing the formula, use the fill handle to copy the formula down, stopping in cell H28.
Transcribed Image Text:
Granger Vacation Properties Date High risk down payment % Low risk down payment % Low risk cut off Lot # Down payment rate 15% 5% 450 House Cost 130767 $ 372705 $ 394976 $ 135587 $ 435782 $ 142881 $ 266692 $ 543283 $ 290433 $ 283444 $ 100307 $ 624582 $ 598217 $ 356725 $ 262367 $ 557585 $ 235620 $ 146243 $ 605747 $ 221998 $ 369,546.00 120,082.00 376,269.00 348,781.00 111,905.00 262,945.00 390,340.00 391,746.00 173,540.00 297,150.00 264,567.00 130,611.00 295,136.00 335,153.00 247,494.00 150,546.00 151,154.00 163,946.00 137,707.00 320,594.00 Credit Score 519 738 489 750 774 635 705 351 431 668 690 350 597 710 544 524 509 596 739 629 Credit Score 100 600 750 Down Payment $55,431.90 $18,012.30 $56,440.35 $52,317.15 $16,785.75 $39,441.75 $58,551.00 $19,587.30 $8,677.00 $44,572.50 $39,685.05 $6,530.55 $44,270.40 $50,272.95 $37,124.10 $22,581.90 $22,673.10 $24,591.90 $20,656.05 $48,089.10 APR 8.00% 6.50% 4.25% % Financed Amount Financed $314,114.10 $102,069.70 $319,828.65 $296,463.85 $95,119.25 $223,503.25 $331,789.00 $372,158.70 $164,863.00 $252,577.50 $224,881.95 $124,080.45 $250,865.60 $284,880.05 $210,369.90 $127,964.10 $128,480.90 $139,354.10 $117,050.95 $272,504.90 Mortgage Rate Rate per period Years 15 15 15 30 20 20 20 30 30 30 20 20 15 30 15 30 20 30 20 20 Granger Vacation Properties Date High risk down payment % Low risk down payment % Low risk cut off Lot # Down payment rate 15% 5% 450 House Cost 130767 $ 372705 $ 394976 $ 135587 $ 435782 $ 142881 $ 266692 $ 543283 $ 290433 $ 283444 $ 100307 $ 624582 $ 598217 $ 356725 $ 262367 $ 557585 $ 235620 $ 146243 $ 605747 $ 221998 $ 369,546.00 120,082.00 376,269.00 348,781.00 111,905.00 262,945.00 390,340.00 391,746.00 173,540.00 297,150.00 264,567.00 130,611.00 295,136.00 335,153.00 247,494.00 150,546.00 151,154.00 163,946.00 137,707.00 320,594.00 Credit Score 519 738 489 750 774 635 705 351 431 668 690 350 597 710 544 524 509 596 739 629 Credit Score 100 600 750 Down Payment $55,431.90 $18,012.30 $56,440.35 $52,317.15 $16,785.75 $39,441.75 $58,551.00 $19,587.30 $8,677.00 $44,572.50 $39,685.05 $6,530.55 $44,270.40 $50,272.95 $37,124.10 $22,581.90 $22,673.10 $24,591.90 $20,656.05 $48,089.10 APR 8.00% 6.50% 4.25% % Financed Amount Financed $314,114.10 $102,069.70 $319,828.65 $296,463.85 $95,119.25 $223,503.25 $331,789.00 $372,158.70 $164,863.00 $252,577.50 $224,881.95 $124,080.45 $250,865.60 $284,880.05 $210,369.90 $127,964.10 $128,480.90 $139,354.10 $117,050.95 $272,504.90 Mortgage Rate Rate per period Years 15 15 15 30 20 20 20 30 30 30 20 20 15 30 15 30 20 30 20 20
Expert Answer:
Answer rating: 100% (QA)
The formula for calculating the rate per period in cell H9 given that all mortga... View the full answer
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the companys Pacific region salespeople just returned to the office with a newly designed...
-
(10 points) Given that ry + xy = 1. 1. Find a solution of the differential equation that satisfies the initial condition y(1) = 10. Answer: y = 2. Find a solution of the differential equation that...
-
Define and explain the Bioptic Telescope
-
The piston/cylinder shown in Fig P4.12 contains carbon dioxide at 50 lbf/in 2, 200 F with a volume of 5 ft3. Mass is added at such a rate that the gas compresses according to the relation PV1.2...
-
On your wedding day your lover gives you a gold ring of mass 3.80 g. Fifty years later its mass is 3.35 g. On the average, how many atoms were abraded from the ring during each second of your...
-
The balance sheet data for Bobs Electronics, Co., November 30, 2010, follow: Requirement 1. The following are three independent assumptions about the business during November. For each assumption,...
-
Refer to the previous question. Suppose that each of the audit activities can be crashed by the amounts indicated in the following table. a. What is the earliest the audit could be completed and what...
-
Detail with the aid of diagrams the design specification and construction details of an artificial sports pitch. Describe how artificial turf surfaces have developed over recent time. Give your views...
-
Is it ethical to sell a product that is. at best, only mildly effective? Discuss. Is it ethical to exploit cultural norms and values to promote a product? Discuss. Is the advertising of Fair &...
-
A Dutch auction is similar in an English auction, but rather than starting the bidding at a low price and increasing, in a Dutch auction the seller starts at a high price and gradually lowers the...
-
Boeing Memo | Draft due Wednesday, Sept 21, 11:45pm Read "Boeing 737 Max 8-A Stalled Communication Take-off?" It is late October 2019. The Boeing Board has just stripped Muilenburg of his role as...
-
Explain 4 factors influencing the national advantages and provide examples for each in case of Indonesia.
-
Consider an academic building with three lecture halls. The maximum capacity of each hall is 200 occupants. In each hall, there are 40 units of 10W lamps being used continuously due to poor natural...
-
What's the role of business in society? Reflect the responsibilities this place on Managers, employees and customer?
-
The question is: A. In worksheet Ex 1of the Excel file provided, model a two-asset portfolio and examine the risk and return characteristic of a two-asset portfolio - using the data provided. In this...
-
Consider the following simplex tableau that arises in the middle of solving a linear programming problem to maximize an objective function 2 = 7x1-x3-4x4+x52x6 in a feasible region with 1, 2, 3, 4,...
-
Find the radius of convergence of? 1.2.3 1.3.5 (2n-1) r2n+1 -1
-
Follow the step-by-step procedures provided to complete this problem for Keller Windows & Doors for the month of March of the current year. Step 1: Start Integrated Accounting 8e software. Step 2:...
-
1. What are the total of the Debit and Credits columns of the general journal (before adjusting entries) for the month of December? 2. What is the total amount owed to Parker Office Products? 3. What...
-
Why are data not lost when sales invoices are purged?
-
Mary Todd is uncertain about several relationships pertaining to audit sampling. As Mary's supervisor, explain the application of audit sampling to (1) GAAS and (2) the components of audit risk.
-
a. Distinguish between sampling risk and nonsampling risk. b. Explain the types of sampling risk that may occur in auditing and their potential effects on the audit.
-
Warren Boyd, a beginning staff accountant, believes that audit sampling applies only to tests of controls, but may be used with all auditing procedures relating to tests of controls. Is Warren...
Study smarter with the SolutionInn App