Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 26, 2020

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

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.

Step by Step Solution

★★★★★

3.41 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

Column 1 This is literally the year the loan is due Column 2 This is the starting value of the ... 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

Step: 3

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

Engineering economy

Authors: Leland Blank, Anthony Tarquin

7th Edition

9781259027406, 0073376302, 1259027406, 978-0073376301

More Books

Students also viewed these Accounting questions

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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?

Answered: 1 week ago

Question

★★★★★

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?

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

For each of the following mutations, is it a transition, transversion, addition, or deletion? The original DNA strand is 5'-GGAC TAG AT AC-3' A. 5'-GAACTAGATAC-3' B. 5'-GGACTAGAGAC-3' C....

Answered: 1 week ago

Question

★★★★★

RogerandJoselent moneytoArnold,BennyandArmandinonesingletransactionin theamountofP 100,000.00.Discussthe lawastohow theloanbecollected(by twocreditors) andbepaid(bythreedebtors)....

Answered: 1 week ago

Question

★★★★★

We select (without replacement) two cards from a pack of 52 cards. The probability that both cards selected are spades is (a) 1 51 52 (b) 13 51 52 (c) 12 13 51 52 (d) 132 51 52 (e) 2 12 13 51 ...

Answered: 1 week ago

Question

★★★★★

Whitegloves Janitorial Service was started 2 years ago by Nancy Kohl. Because business has been exceptionally good, Nancy decided on July 1, 2012, to expand operations by acquiring an additional...

Answered: 1 week ago

Question

★★★★★

1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation. 1. Prepare depreciation schedules using Straight-Line, Activity Based, and...

Answered: 1 week ago

Question

★★★★★

A house with a total living area of 2,500 square feet would cost $110 per square foot to reproduce new. It has an expected economic life of 50 years and is estimated to have an effective age of five...

Answered: 1 week ago

Question

★★★★★

1. Luther Corp. issued $50,000,000 par value 8% convertible bonds at 102. If the bonds had not been convertible, the company

Answered: 1 week ago

Question

★★★★★

In real estate, what are the competing interests between priority of federal vs. state tax liens? I need typed answer with explanation

Answered: 1 week ago

Question

★★★★★

Consider the following root's loci. 5 4 3 2 O Imaginary Axis (seconds) 3 -4 -5 -20 Root Locus -15 -10 -5 Real Axis (seconds) The angle of departure from the complex poles can be approximated by: A...

Answered: 1 week ago

Question

★★★★★

Use pivot table, privot chart, and basic excel functions to answer the following questions for data in "econ" tab. 1. For each of the variables in the next tab "econ": what is the average, the...

Answered: 1 week ago

Question

★★★★★

Question 18 1 pts For the gear trains sketched in the given figures, compute the output speed of the output shaft if the input shaft rotates at 1750 rpm (Accuracy .X RPM, don't include +'s or -'s...

Answered: 1 week ago

Question

★★★★★

Explain what cloud service the New York Times successfully utilized and the benefit this solution provided.

Answered: 1 week ago

Question

★★★★★

all the following is an example of a fixed cost except: any cost that changes in proportion to the changes in the level of activity, rent paid for factory, any cost that remains constant regardless...

Answered: 1 week ago

Question

★★★★★

How do the principles of (a) Physical controls and (b) Documentation controls apply to cash disbursements?

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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,...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

"The higher real wages earned by American workers primarily reflect the fact that Americans have a greater inherent ability to produce goods and services than do foreign workers." Evaluate.

Answered: 1 week ago

Question

★★★★★

Why aren't the tools of product market analysis directly applicable to the resource market?

Answered: 1 week ago

Question

★★★★★

Compare and explain the significance of the substitution and output effects as they apply to resource pricing. What relationship, if any, do they bear to the income and substitution effects discussed...

Answered: 1 week ago

Previous Question Next Question