Question: 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

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, compounded annually, in order to achieve your goal?

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 required to pay the loan off in equal annual installments over a period of 8 years, what is the amount of each installment?

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

write a research paper ,the paper should be in the form of a discussion of leadership and management approaches to a specific cybersecurity topic. Example 1: Incorporating Emerging Technologies Into...

Please help me solve it using excel .. Please provide and answer to the following problems using Excel. For your Excel answer. FIN220 Fundamentals of Financial Management Excel Assignment Please...

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

Please help me solve this using excel. The three methods Iwoukd like to the rate function in excel if possible. Not sure what function for oayback in excel. I am trying to do , IRR, Payback and am...

Please help me solve this using EXCEL or financial calculator, or a step by step. Thank you Your uncle is about to retire, and he wants to buy an annuity that will provide him witt $56,149 of income...

Hi Please help me solve this simple excel take home test. I will give positive feedback for your help thansk! Below is simple question and the data for the company R3000. DATA: ID Ticker ID Ticker ID...

A. Hello, This is the first part of an assignment that i already did. Posting the screen shot. After looking at it please help me solve the second excel. That i will also attach in this question....

please help answer 2 & 3 using excel Central Florida Computer Company Central Florida Computer Co. (CFCC), a leading manufacturer of IBM look-alike computers, is considering the installation of a new...

Please help me solve question #6, what is the maximum price that Waltham should pay to equity shareholders for Artforever.com? Assignment Overview Waltham, Inc., a publicly traded firm, is...

PLEASE ANSWER ALL QUESTIONS. The calculations have to be using Excel. 1)You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year,...

The relationship between the strength and fineness of cotton fibers was the subject of a study that produced the data below. a. Draw a scatter diagram. b. Find the 99% confidence interval for the...

1.Explain the meaning of the following terms Knowledge Skill- Talent- Competency- Profession - 2. Describe four managerial skills that managers need to be effective in running a sugar milling...

What is the tax treatment of incentive stock option for employers the employer receives a tax deduction for the exercise price on the date the employee purchase the the employer detect the element of...

I am coding a program in python that would be able to take two user inputs of pH and TSS (total suspended solids). tss= int(input("What is your TSS? ")) pH= int(input("What is your pH")) Coag_dose =...