Question

(Solve using Excel and provide steps to build formulas) A company estimates that it will need...

(Solve using Excel and provide steps to build formulas) A company estimates that it will need $199,000 in 55 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 3.1% compounded​ monthly, how much should each payment​ be?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Below is the formula:

Please rate.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company estimates that it will need $138,000 in 11 years to replace a computer. If...
A company estimates that it will need $138,000 in 11 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 5.1 % compounded​ monthly, how much should each payment​ be?
A. A company estimates that it will need $83,000 in 11 years to replace a computer....
A. A company estimates that it will need $83,000 in 11 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 4.2% compounded​ monthly, how much should each payment​ be? B. You can afford monthly deposits of $260 into an account that pays 3.3% compounded monthly. How long will it be until you have $9,500 to buy a​ boat?
A company estimates that it will need $139,000 in 18 years. if it eatablishes a sinking...
A company estimates that it will need $139,000 in 18 years. if it eatablishes a sinking fund hy making fixed monthly payments into an account paying 5.4% compounded monthly, how much should each payment be? The amount of each payment should be:?? (Round to the nearest cent)
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows...
Solve using financial calculator and show steps please A borrower is evaluating a loan $100,000 with...
Solve using financial calculator and show steps please A borrower is evaluating a loan $100,000 with annual rate of interest at 12%. He anticipates making monthly payments of $2,100 then a lump sum payment of $10,000. How long is he expecting to be paying this loan rounded to the nearest number years / months?
Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a...
Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. a. How much money will you still owe on the loan after making one full year of payments? b. How much money will you still owe on the loan after making 15 full years of payments? c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from...
I need the EXCEL formula for the following questions, please. What is the formula to calculate...
I need the EXCEL formula for the following questions, please. What is the formula to calculate how much a savings account would be worth if the initial balance is $1,000 with monthly deposits of $75 for 10 years at 4.3% annual interest compounded monthly? What is the formula result? You want a savings account to grow from $1,000 to $5,000 within two years. Assume the bank provides a 3.2% annual interest rate compounded monthly. What is the formula to calculate...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to answer the following questions. Print an Excel spreadsheet that presents your answers to these TVM questions and also print the formula sheet that shows how you calculated your answers.   1 Calculate the present value of 120 monthly payments of $300 at an annual rate of 8%. The payments are made at the end of each month. 2 You are financing a new car with...
(Nonannual compounding using a calculator​) Jesse Pinkman is thinking about trading cars. He estimates he will...
(Nonannual compounding using a calculator​) Jesse Pinkman is thinking about trading cars. He estimates he will still have to borrow ​$30,000 to pay for his new car. How large will​ Jesse's monthly car loan payment be if he can get a 7​-year (84 equal monthly​ payments) car loan from the​ university's credit union at an APR of 7.1 percent compounded​ monthly? ​ Jesse's monthly car loan payment will be ​$ ​(Round to the nearest​ cent.) (Compound annuity​) You plan on...
Solve the following: 1. You want to be a millionaire in 25 years. If you can...
Solve the following: 1. You want to be a millionaire in 25 years. If you can earn 10% on your investments, how much do you have to save each year to hit that $1,000,000 mark? Table______________________ 2. Amy is 65 and has $350,000 in her retirement account. An actuary has determined that if her investments earn 7%, she can withdraw $32,300 annually. How many more years does the actuary expect Amy to live? Table______________________ 3. Karla sued her landlord 5...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT