Answer all subpart. Vanna has just financed the purchase of a home for $200 000.She agreed to

Fantastic news! We've Found the answer you've been seeking!

Question:

Answer all subpart.

Vanna has just financed the purchase of a home for $200 000.She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a compounded monthly.

a.Create an amortization table using a Microsott Excel spreadsheet.In your answer include all the formulas used.

b.How long will it take to repay the loan?

c.How much will be the final payment? d.Determine how much interest she will pay for her loan.

Related Book For answer-question

Engineering economy

ISBN: 978-0073376301

7th Edition

Authors: Leland Blank, Anthony Tarquin

See More Books

Posted Date: Aug 26, 2020 11:54 AM

See More Questions

How long will it take for monthly payments interest rate on the loan is: a. 6% compounded monthly? b. 7% compounded monthly? c. 8% compounded monthly? d. 9% compounded monthly
How long will it take for monthly payments interest rate on the loan is: a. 7.5% compounded annually? b. 7.5% compounded semiannually? c. 7.5% compounded quarterly? d. 7.5% compounded monthly?
How long will it take to save $15 000 by making deposits of $90 at the end of every month into an account earning interest at 4% compounded quarterly?
The rigid bar AB is supported by a pin at B and by two the cables AC (perpendicular to the beam) and AD (inclined with respect to the beam) attached at A as shown in Fig. 3. A C 30 in D B 80 in...
Extended Debye-Hckel equation. Use Equation 7-6 to calculate the activity coefficient () as a function of ionic strength () for = 0.0001, 0.0003, 0.001, 0.003, 0.01, 0.03, and 0.1 M. (a) For an...
At January 1, 2017, Apex Inc. had accounts receivable of $72,000. At December 31, 2017, the accounts receivable balance was $59,000. Sales revenue for 2017 was $420,000. Sales returns and allowances...
Does structural modeling represent classes or objects?
Refer to the Auditing in Practice feature, "Professional Skepticism." a. What is professional skepticism? b. Why is professional skepticism necessary to detecting fraud? c. What are the key behaviors...
For 2016, Theta Corporation had net income of $2,250,000. At the beginning of the year, there were 800,000 shares outstanding, and halfway through the year the company issued 130,000 new shares. If...
Montreal Electronics Company manufactures two large-screen television models: the Nova, which has been produced for 10 years and sells for $900, and the Royal, a new model introduced in early 20x0,...
Question 3 Winnie is a junior financial analyst of PKP Corporation and has been instruct to analyze two capital investment projects, namely, Project Pfizer and Project AZ. Both of the projects have...
Create a metaphor, simile, or very short (2-3 sentences) story to illustrate shifts in the aggregate supply curve. You were recently hired by Citigroup in the currency management department. Your...
In September 2000, Amazon offered a Planet of the Apes DVD to customers using a Netscape Web browser for $64.99. Several seconds later, however, a similar search performed with Microsoft Internet...
Newel1 Corp. sells household cleaners producing a revenue stream that has remained unchanged in the last few years. The firm does not expect any change in its sales or earnings in the next several...
Write a Python function (findMinAndMax) that, given a list of values (values), returns a tuple containing the minimum value and the maximum value. Note: Do not use predefined min() or max()...
2. Write a C++ program that does the following: a. Prompts the user for a positive integer, validating the input until the user enters a positive integer. b. Prints the count of zeroes in the...
How can citizen science initiatives, crowdsourced monitoring platforms, and geospatial technologies be leveraged to enhance biodiversity monitoring, environmental surveillance, and public engagement...
How do the principles of (a) Physical controls and (b) Documentation controls apply to cash disbursements?
Assume the inflation rate is 4% per year and the market interest rate is 5% above the inflation rate. Determine (a) The number of constant-value dollars 5 years in the future that is equivalent to...
According to Descartes rule and Norstroms criterion, the number of positive i* values for the following cash flow sequence is: (a) 1 (b) 2 (c) 3 (d)4 Year Revenue, S 25,000 15,000 4,000 18,000 Cost,...
A couple planning for their child's college education can fund part of or all the expected $100,000 tuition cost from their own funds (through an education IRA) or borrow all or part of it. The...
If you let go of a helium balloon, it quickly rises. As it rises, the balloon gets larger and larger until it pops. Why does the balloon expand as it rises?
Elephant seals do deep dives to forage for food. The energy used by the seals in diving depends on their body composition; for example, fatter seals use less energy to swim to the surface at the end...
Early airshipscraft that relied on large volumes of low density gas to rise from the groundwere filled with hydrogen, but safety concerns necessitated a switch to helium. When an airship made the...

Answer all subpart. Vanna has just financed the purchase of a home for $200 000.She agreed to

Question:

Expert Answer:

Column 1 This is literally the year the loan is due Column 2 This is the starting value of the ... View the full answer

Engineering economy

Students also viewed these accounting questions