Question: Develop a What If amortization table that allows the table to automatically adjust to whatever interest rate and original balance are entered. The number of

Develop a "What If" amortization table that allows the table to

Develop a "What If" amortization table that allows the table to automatically adjust to whatever interest rate and original balance are entered. The number of years is fixed at ten. Payments are monthly and are made at the end of the month. The table will be graded assumming that the Loan Amount is $50,000 and the Yearly Interest Rate is 7.2%. Yearly Interest Rate: 7.20% Loan Amount: $50,000.00 Paid on Loan Ending Balance Payment: All Payments: All Interest: Monthly Pmt Interest Beginning Payment Paid on Num Month Rate Balance Amount Interest 1 1-Jan-10 2 1-Feb-10 3 3 1-Mar-10 4 4 1-Apr-10 5 1-May-10 6. 1-Jun-10 7 1-Jul-10 8 1-Aug-10 91-Sep-10 101 1-Oct-10 11 1-Nov-10 12 1-Dec-10 13 1-Jan-11 14 1-Feb-11 15 1-Mar-11 16 1-Apr-11 17 1-May-11 18 1-Jun-11 19 1-Jul-11 201-Aug-11 21 1-Sep-11 22 1-Oct-11 23 1-Nov-11 24 1-Dec-11 25 1-Jan-12 26 1-Feb-12 27 1-Mar-12 281 1-Apr-12 GoalSeek3 Solver Problem 1 SolverProblem2 SolverProblems : GoalSeek1 GoalSeek2 Data Questions Rules Amortization Vlookup +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1. Using examples from the case study critically examine the 5 forces which establish the rivalry in the global pharmaceutical industry. 2. Using examples from the case study critically examine the...

Please help with steps seventeen through 21. Hokie Fitness Equipment & Accessories, Inc. is a retailer that sells fitness equipment and accessories. The manager of Hokie Fitness Equipment &...

I am working on a excel two input data table and having issues getting it work properly. It's Question 2D on the uploaded documents. One is the word version with question, 2nd is the excel version. I...

FINANCIAL PROJECTIONS EXERCISE (CASE STUDY) (Mr. Howard, Inc.) this case exercise is designed to give you some practical, hands-on experience in prep p e forma ancial projections. Please note that...

The example exercise is to work through a loan amortization example using Excel. Go to the Exercise 1 worksheet. The example loan conditions to be entered into the Loan Terms table are: Loan amount...

Answer it in real quick time will get the vote!!! Develop an assessment of each of the following problems: 1. Calculate the monthly mortgage payment of principal and interest for the a loan with an...

Develop an assessment of each of the following problems: Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest...

Develop an assessment of each of the following problems: 1. Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated...

Develop an assessment of each of the following problems Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual staled interest...

Suppose that you are solving an LP in standard form with 5 variables r1,..., r5, 2 constraints, and the following objective function minz = x1 + 7x2 +5x3+ x4 + 6x5. You add two artificial variables y...

A profit center manager of a company's eastern sales division is looking at decreasing the following costs: direct labor, utilities, and purchasing, which is allocated by the number of requisitions....

What is the pumping length of string of length x ? x - 1 2 x x + 1 x

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

4. Think of a topic that you find excruciatingly dull (for example, balancing your checkbook, studying for a required course you dont like, or taking a summer or part-time job doing something utterly...

2. Informative speeches are everywherein your classroom, on the news, and in your community. Watch an informative speech (or read a transcript, available at the Web sites of many government agencies...

5. Imagine a process you do every day, such as driving a car. Think about how you would explain the process to someone whos never done it or even seen it done before. Consider different ways you...