A young engineer's stating salary is 56,000. The engineer expects annual raises of 3%. The engineer deposit 15% of the annual salary at the end of each year in a savings account. What is the savings interest rate must be so that there will be $200, 000 in savings for a business start-up after 15 years? Your spreadsheet must include at least columns for the year (year 1, year 2 .), the year's salary, the year's deposit, and the year's cumulative savings. Show the formula you use for calculation.

A young engineer's stating salary is 56,000. The engineer expects annual raises of 3%. The engineer deposit 15% of the annual salary at the end of each year in a savings account. What is the savings interest rate must be so that there will be $200, 000 in savings for a business start-up after 15 years? Your spreadsheet must include at least columns for the year (year 1, year 2 .), the year's salary, the year's deposit, and the year's cumulative savings. Show the formula you use for calculation.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 34P

See similar textbooks

Similar questions

Now assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
A young engineer’s starting salary is $52,000. The engineer expects annual raises of 3%. The engineer will deposit 10% of the annual salary at the end of each year in a savings account that earns 4%. How much will the engineer have saved for starting a business after 15 years? We suggest that the spreadsheet include at least columns for the year, the year’s salary, the year’s deposit, and the year’s cumulative savings.
A young engineer’s starting salary is $75,000. The engineer expects annual raises of 2%. The engineer will deposit 15% of annual salary at the end of each year in an investment account that averages 6% interest. How much will the engineer have saved for retirement after 40 years?
A young engineer’s starting salary is $65,000. The engineer expects annual raises of 2.5%. The engineer will deposit a constant percentage of annual salary at the end of each year in a savings account that earns 5%. What percentage must be saved so that there will be $1 million in savings for retirement after 35 years?
You have just entered a two-year part-time Executive MBA. The tuition fee is $15,000 per year payable at the beginning of each year. Before the program you eamed $40, 000 per year. Your expected salary after graduation. is $55, 000 per year. You can invest your money at 8%. Assume that you will work for 30 years after graduation. The salary differential of $15,000 will continue through this period. How much is your EMBA worth?
The average age of engineering students at graduation is a little over 23 years. This means that the working career of most engineers is almost exactly 500 months. How much would an engineer need to save each month to accrue $5 million by the end of her working career? Assume a 9% interest rate, compounded monthly.
The manager has 5 employees whose combined salaries through the end of this year are $300,000. If he expects to give an average raise of 7% each year. If the interest rate is nine percent per year, calculate the present worth of the employees' salaries over the next five years.
The president of a growing engineering firm wishes to give each of 50 employees a holiday bonus. How much is needed to invest monthly for a year at 12% nominal interest rate, compounded quarterly, so that each employee will receive a $1,200 bonus?
Rendon Labrador, a focus-oriented person, is creating a bank retirement account. By the time he retires from work in 20 years, he wants to have accumulated P2,000,000 in the account. A local bank is ready to create a 20-year retirement account with an annual interest rate of 8% compounded quarterly. He wants to begin with a deposit at the conclusion of the first semiannual period and increased the deposit by Php 500.00 per semiannual, what should be the size of his first deposit? Answer:PHP 13,633.72 >I need the solution please
A man who is 30 years old at the start of the year, is considering getting an MFM degree. He currently earns $40,000 per year and expects to continue earning that amount for the rest of his working life (until age 65). He will give up his income for two years and will pay $20,000 per year in tuition, if he attends business school. In exchange, he expects a raise in his salary after completing his MFM. Assume that the post-graduation salary grows at a 5% annual rate and that the discount rate is 8%. What is the minimum expected starting salary after graduation for him that makes attending business school a positive-NPV investment? (Assuming that all cash flows happen at the end of each year.) Use Time Value of Money calculations.
An electrician is 27 years old and starting a 401k. The employee plans to invest $350 per month with an expected interest rate of 3.5%, compounded monthly. After 30 years of working, the employee wants to have $200,000 in the retirement account. What is the difference between the actual balance and the employee's goal?A spreadsheet was used to calculate the correct answer. Your answer may vary slightly depending on the technology used. The actual balance is $29,340.64 higher than the goal. The actual balance is $29,340.64 lower than the goal. The actual balance is $22,394.46 higher than the goal. The actual balance is $22,394.46 lower than the goal.