Question: Please help me solve this using Excel. Thank you! 1.You obtain an installment loan to pay for graduate school in the amount of $30,000. If

Please help me solve this using Excel. Thank you!

1.You obtain an installment loan to pay for graduate school in the amount of $30,000. If the lender charges you 7% interest and you are required to pay the loan off in equal annual installments over a period of 8 years, what is the amount of each installment?

2.If you place $4,000 a year in your pension plan and the plan earns 9% per year, how much will you have available for your retirement in 40 years?

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 Finance Questions!

Environmental Business Consultants (EBC) compensates all of its employees as salaried workers. Thus, EBC considers its labor cost as fixedthat is, EBC consultants are paid their full salary and...

Please Help me solve these using excel. Thank you 1.You retired today and you have $2,000,000 in your retirement account. If your money will grow at a rate of 8% yearly after you retire and you wish...

Please Help me solve these using excel 1.You need to have $10,000 to pay for your wedding in 5 years. How much do you need to deposit at the end of each year into a bank that pays 4% interest,...

PV and FV functions in Excel please do not answer if you are not 100% sure of the answer ! :) Also, PLEASE explain HOW you got your answer. I have to show my work in Excel so explain how I get my...

Must be solved using the PV and FV functions in Excel. 2) You obtain an installment loan to pay for graduate school in the amount of $30,000. If the lender charges you 7% interest and you are...

You obtain an installment loan to pay for graduate school in the amount of $30,000. If the lender charges you 7% interest and you are required to pay the loan off in equal annual installments over a...

Please help me solve this homework case. Thank you Case Study Alpine Wear, Inc. Ann, Austin, the recently hired treasurer of Alpine Wear, Inc., was summoned to the office of Billy Joe Durango, the...

Need help figuring out problem #40, #42, and #45 in the attached document. I have the answers for the problems, but need to see how they are worked out. FIN 142 - Real Estate Finance Problem Set 2 1....

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Assume Pacific Coast Railway is considering hiring a reservations agency to handle passenger reservations The agency would charge a flat fee of $15,000 per month plus $3 per passenger reservation....

The data set below contains the amount that a sample of nine customers spent on lunch ($) at a fast-food restaurant. Complete parts (a) through (d) below. 4.29 5.86 6.48 7.48 7.54 8.55 8.44 9.88 a....

Steven s finance professor in college convinced him that the stock market is an efficient market. Steven is 2 6 years old and just starting to save for his retirement by opening up an IRA account....

We implemented the C_RefUnsortedList by maintaining a single reference, the last element of the list. Suppose we changed our approach so that we maintain two references into the linked list, one to...