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
-
Let X1 and X2 be discrete random variables with joint probability distribution find the probability distribution of the random variable Y = X1X2. 1,2,3, T1 = 1,2; 12 = f(21,22) 10, 16 elsewhere.
-
Indian Plastics Ltd. purchased one Tempo delivery van under hire-purchase agreement from Hindustan Auto Ltd. On January 1, 2015, payments were to be made of 2,000 on that date and the balance in...
-
Identify the sales tasks and skills required for this job.
-
(Multiple Choice) The following information relates to the first three questions in the list that follows. A village levied property taxes in the amount of $ 800,000 for calendar year 2013. By year-...
-
In order to feasibly implement the solution, analyze what would need to be considered. For instance, what resources (people, financial, etc.) would be involved? Or, what internal and/or external...
-
The statement of cash flows for the manufacturing firm Deluxe Rain Shower Heads is shown below. Using both the Direct Method Statement of Cash flows for the Years Ending: Cash flows from Operating...
-
The term "corporate social responsibility" is today best defined in the U.S. by: a. federal statutory incorporation law. b. Securities and Exchange Commission (SEC) Rule 10b(5) c. Kant's ethical...
-
How would you perform a test of the predictions of the capital assest pricing model given historical data on asset and market portfolio returns?
-
Critique the accuracy of all estimates and explain some of the factors that determine the firms' equity, debt and therefore weighted average cost of capital. Keuring Keycrop Risk Free Return 3.87%...
-
A small oil company, Hastelloy, uses micro - moving Coriolis axle gauges on its construction site. Emerson wants to replace it with F series axle meters. This replacement process will apply to the...
-
1. One assumption underlying Modigliani and Miller's theories of capital structure is that there is no difference between 'home - made' gearing and corporate gearing. Explain this assumption and...
-
Discuss the goal of financial management around the world from finance marketing and professional perspective?
-
Prepare a Proposal to respond to the RFP. You may respond simulating with hypothetical details of a contractor company that exists, or that you make up. The scenario is Imagine you wish to book an...
-
Why are stocks usually more risky than bonds?
-
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?
-
Using Rayeigh's method, determine the fundamental natural frequency of the system shown in Fig. 8.42. Disc, mass moment of inertia 5 kg-m Steel shaft, dia. 5 cm + O 0.8 m -0.2 m- FIGURE 8.42...
-
Solve Problem 8.73 using the Rayleigh-Ritz method with the mode shape \[U(x)=c_{1} \sin \frac{\pi x}{2 l}+c_{2} \sin \frac{3 \pi x}{2 l}\]
-
Find the first two natural frequencies of a fixed-fixed uniform string of mass density \(ho\) per unit length stretched between \(x=0\) and \(x=l\) with an initial tension \(P\). Assume the...
Study smarter with the SolutionInn App