Q: If she invests $1900 into a savings account for those 5 years at 6.5% interest, compounding…
A: Given that: Future value = $2500 Time period = 5 years
Q: If she can sell the car after 3 years for $40,000, what is the total amount she will pay over the…
A: Loan amortization refers to a schedule which is prepared to shows the periodic loan payments, amount…
Q: anny is saving towards his vacation. He has determined that the total cost including airfare and…
A: Given: Cost of vacation 5000 Monthly savings 400 Time of deposit Month-end Annual…
Q: Krystal plans to save $500 at the end of Year 1, $600 at the end of Year 2, and $700 at the end of…
A: Money she will save by end of year 3 is future value of all yearly payments
Q: Rosa Burnett needs $4,000 in three years to make the down payment on a new car. How much must she…
A: Future value required for car = $4,000 Interest Rate = 2.5% Time period = 3 years
Q: The Fergusons want to purchase their first home and need $14,300 for a down payment. They can save…
A: The present value is the value of the sum received at time 0 or the current period. It is the value…
Q: Kristina is going to finance new office equipment at a 5% rate over a 1.5 year term. If she can…
A: Using excel PV function
Q: Jane is planning on saving for a car purchase in 8 years, however, she can only contribute to the…
A: Here we will use the concept of annuities and time value of money. The amount invested by Jane at…
Q: James and Kate would like to have $30,000 in 6 years in order to purchase anew mini van. What amount…
A: Annuity refers to series of annual payment which is paid or received at start or ending of specific…
Q: Ingrid wants to buy a $22,000 car in 6 years. How much money must she deposit at the end of each…
A: Future Value = $22,000 Time Period = 6 Years Interest Rate = 5.8%
Q: Toni Torres wants to save $1,200 in the next two years to use as a down payment on a new car. If her…
A: An annuity series in which an investor saves the amount at the end of each period for a specified…
Q: Sue decides to start saving money for a new car. She knows she can invest money into an account…
A: According to time value of money, FV=PV×1+RMM×N Where, PV = present value R = rate of interest M=…
Q: Carol wants to have $500,000 when she retired in 25 years. Her credit union has an ordinary annuity…
A: GIVEN, FV = $500,000 N=25 M=12 R=4%
Q: Katy has decided she wants to put money aside for a $8000 downpayment on a house. She figures she…
A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…
Q: To help with a down payment on a home, Jenny is going to invest. Assuming an interest rate of 1.67%…
A: Using excel PV function
Q: Suppose that Charles and Nancy are saving to buy a house. They have $20,000 in the bank, but know…
A: The concept of the time value of money states that the same amount of money has more value today…
Q: Hannah wants to have $ 7500 to help pay for a new deck in 16 years. If she wants to put her money…
A: GIVEN, Future Value = $7500 Interest rate(r) = 6.25/100 = 0.0625 Time Period(t) = 16 years Present…
Q: Hudson would like to purchase a new car for $25,000. How much will his monthly payments be if he…
A: The monthly payment amount can be calculated with the help of present value of annuity function
Q: how much do you need to put in an account today (now), so that you will have $15,000 in four years’…
A: Information Provided: Future value / Amount = $15,000 Interest rate = 5% Time = 4 years
Q: Lena is regularly saving money in order to buy a new car at the end of 7 years. If the car is 30,000…
A: Cost of Car is 30,000EUR Interest rate is 2% Time period is 7 years or 7×12 = 84 months To Find:…
Q: Calculate the amount of money that Emily needs to set aside from her bonus this year to cover the…
A: We need to use the concept of time value of money to solve the question. According to the concept of…
Q: Cheryl is setting up a payout annuity with her bank. She wants to receive a payout of $1200 per…
A: Using excel PV function
Q: Hannah wants to have $ 1500 to help pay for a new deck in 10 years. If she wants to put her money…
A: Time has been valuable in all aspects but in terms of finance, time has a money value. The worth of…
Q: How much money should she save at the beginning of each 3 months
A: Value at a future point of time is equal to sum of savings made and interest on those savings.…
Q: How much is the annual interest rate, assuming compounding annually Molly should aim at if she…
A: Future Value is the value of current investments at a certain future date at the assumed…
Q: A middleclass woman wants a luxury bag so much that she is willing to pay the bag in installment as…
A: Monthly payment in year 1 = P 5000 Monthly payment in year 2 = P 4000 Monthly payment in year 3 = P…
Q: Alexandria wants to receive $12,000 a year for 8 years. How much must Alexandria invest today in an…
A: Computation:
Q: Kristy Joe deposits $130 each month in an ordinary annuity to save for a new car. If the annuity…
A: The future value of the investment is computed to find total saving can be made for the new car.…
Q: How much do you need to save each year for 30 years in order to have $775,000, assuming you are…
A: Given information: Future value amount is $775,000 Interest rate is 8% Number of years is 30
Q: Calculate how much will Sonja have in a savings account 12 years from now if she deposits RM 3,000…
A: The future value at the end of 12 years is the sum of future values of deposits made at year 0 and…
Q: Mary wants to have $14000 for a trip to Mexico in five years. How much does she need to deposit at…
A: The future value of annuity would be considered the value accumulated in future with a view to…
Q: Katie wants to save $1500 over the next two years to use as a down payment on a new car. If her bank…
A: I/Y = rate = 5%/12 = 0.6% Nper = Number of periods = 2*12 = 24 FV = Future value = -1500 CPT PMT =…
Q: Your goal is to retire in 20 years. You plan to start on this path by saving $200 a month. If you…
A: Given: No. of years= 20 yrs No. of months= 240 (20*12) Rate= 6% annually Payment each month= $200…
Q: Hannah wants to have $1500 to help pay for a new deck in 13 years. If she wants to put her money…
A: Present Value = Future value / e^rt Where r = 8.50% t = 13 years
Q: Latoya wants to save money to buy a motorcycle. She invests in an ordinary annuity that earns 7.8%…
A: Given information: Interest rate is 7.8% Future value of annuity is $6,000 Number of years is 5…
Q: To help out with her retirement savings, Kaitlin invests in an ordinary annuity that earns 4.8%…
A: Rate of Interest = 4.8% Compounded Monthly Time Period(t) = 18 years n = 12 Future Value = $97,000…
Q: Ms. H wants to save $1500 over the next two years to use as a down payment on a new car. If her bank…
A: I/Y = rate = 5%/12 = 0.416667% Nper = Number of periods = 2*12 = 24 FV = Future value = $1500 CPT…
Q: Kala wants to save money to buy a motorcycle. She invests in an ordinary annuity that earns 4.8%…
A: Here, Interest rate = 4.8% compounded annually Future value of annuity = $5,000 Time period = 3…
Q: Aini wishes to have 93,000USD to purchase a car in 6 years as part of her financial goals. How much…
A: Future Value = 93,000 USD Time Period = 6 Years Interest Rate = 8%
Q: Your parents agree to pay half of the purchase price of a new car when you graduate from college.…
A: The simple interest is calculated by multiplying interest rate by principal amount for a certain…
Q: as just bought a house. She estimates that the roof will have to be renewed at a cost of €25,000…
A: The given problem can be solved using PMT function in excel. PMT function computes savings/…
Q: Becca wants to save $900 per quarter for 3 years towards the purchase of an appliance. She feels…
A: Total number of quarters in 3 years = 4 quarters × 3 years = 12 quarters Thus, Becca will…
Q: Suppose you wish to invest in an annuity so that you will have $120,000 at some future date for your…
A: We invest $350 monthly at a interest rate of 5.85% per month in order to give the child $120,000 at…
Q: To save for a down payment on a home, suppose you decide to invest in an annuity that pays 7.0%…
A: This is the question of annuity. Annuity is the stream of constant cashflow occurring at regular…
Q: Hannah wants to have $ 7500 to help pay for a new deck in 13 years. If she wants to put her money…
A: The amount required to invest today can be calculated with the help of future value function
Q: Aunt Zelda’s son starts college in 5 years for which she will need $15,000 payable at the end of…
A: Aunt Zelda will buy an annuity at the beginning of year 5 that will pay $15000 for college at the…
Q: Discuss the meaning of "the present value of a future amount"? Give the equation for present value?…
A: Money grow by the time and interest rate and future value of money is more than what today due to…
Q: Your friend Anne is planning to invest $400 each year for four years and will earn a rate of 6…
A: Given information: Annuity payment : $400 Rate of interest : 6% Time period : 4 years Since, the…
. Calculate the amount that Jinhee needs to save each year for the down payment on a new car, assuming she can earn 13% on her savings?
2. Calculate how much she will need to save on a monthly bases assuming monthly compounding. for each scenario, how much of her down payment will come from interest earned?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- Edwards company just hired another employee Jane, the Edwards company provides supplemental retirement benefits to its employees realizing the insufficiency of the Social Security benefits or comfortable retirement life Edwards has asked you to perform the necessary computations pertaining to the retirement benefit for Gene. Jane’s current salary is $40,000. Jane will be entitled to the supplementary retirement benefits after 20 years of work the start of the 21st year The retirement plan will last for 25 years per company practices Jane will be granted with a year and salary increase of 2% per year effective January 1 of each year that she works the amount of annual retirement benefit is going to be 45% of James salary right before the start of the retirement and will be paid at the start of each year. Any invested funds for pension will earn 4% compounded annually, compute Jane’s annual retirement benefit. Assume James’s retirement benefit is $32,000 what amount must be on deposit…PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS2.Alejandra Marrufo wants to know how much she should deposit today, so that in 10 years she will have the amount (VF) of 77,150.00, which she needs to make a pension payment for her domestic worker, a) if the account pays 8.125% interest compoundable semiannually; b) if the account pays 9.65% compoundable monthlYou have to decide whether or not to participate in the employer match program at your work. If you place 8% of your gross pay into a retirement account, your employer will match it. You plan to retire in 30 years. You expect to earn 6% return on your investment. How much will you have in the account if your average annual gross salary is $50,000? A. $316,232.80 B. $22,973.96 C. $45,947.92 D. $632,465.60 Using the same information as the previous question, assume that you want to increase your portion of the contribution to 10%. The employer will only match up to 8%. How much would you have in this situation? A. $692,523.80 B. $711,523.80 C. $316,232.80 D. $632,465.60
- Maria has just finished her thirty-second year with her company and is getting ready to retire. During her thirty-two years, Maria's average annual salary was S62,544. How much can Maria expect to receive from Social Security annually if she were to retire today? (Assume she will receive 55% of his average annual salary.) a. $96.943.20 b. $34.399 92 c. S28.144.00 d. $62.544A new graduate has taken a job with an annual salary of $60,000. She expects her salary to go up by 2.5% each year for the first five years. Her starting salary is stored in cell A4 of an Excel worksheet, and the salary increase rate is stored in cell B4. Construct a table with years 1 through 5 in cells A6:A10 and her salary in cells B6:B10. Write the formula for her salary in year 2 (in cell B7) that can be copied and pasted correctly in cells B8 through B10Claire is planning annual end of year withdrawals from her tax-free account after retirement for 35 years. She has Principal of $755,000, Investment return is 6%, Initial withdrawal $40,000 and annual increase of withdrawal $1,000. Show the work if Claire is possible to continue withdrawing for 35 years? In order for her to do that, what does she have to do?( show excel function & cell reference)
- What does Shelley need to save monthly to make sure she is on track to reach her retirement goal of having $440,000 saved by the time she reaches age 65? She is 48 years old, has been contributing $400 per month and has $180, 000 in her RRSP. Assume she will make an annual return of seven percent. Select one: a. $1275 b. $336 c. $681 d. $1133Answer the following problems and explain it step by step: 1. 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.) 2. Bob and Rose are both 62 years old and plan to retire in 3 years. They will receive $5,000 per month after taxes from pension plans and $1,000 per month after taxes from Social Security after retirement. Regrettably, their living…Emily Smith just received a promotion at work that increased her annual salary to $42,000. She is eligible to participate in her employer’s 401(k) retirement plan to which the employer matches, dollar for dollar, workers’ contributions up to 5% of salary. However, Emily wants to buy a new $25,000 car in 3 years, and she wants to have enough money to make a $10,000 down payment on the car and finance the balance. Fortunately, she expects a sizable bonus this year that she hopes will cover that down payment in 3 years. A wedding is also in her plans. Emily and her boyfriend, Paul, have set a wedding date two years in the future, after he finishes medical school. In addition, Emily and Paul want to buy a home of their own in 5 years. This might be possible because two years later, Emily will be eligible to access a trust fund left to her as an inheritance by her late grandfather. Her trust fund has $80,000 invested at an interest rate of 5%. a. What will be the value of Emily’s trust…
- Emily Smith just received a promotion at work that increased her annual salary to $42,000. She is eligible to participate in her employer’s 401(k) retirement plan to which the employer matches, dollar for dollar, workers’ contributions up to 5% of salary. However, Emily wants to buy a new $25,000 car in 3 years, and she wants to have enough money to make a $10,000 down payment on the car and finance the balance. Fortunately, she expects a sizable bonus this year that she hopes will cover that down payment in 3 years. A wedding is also in her plans. Emily and her boyfriend, Paul, have set a wedding date two years in the future, after he finishes medical school. In addition, Emily and Paul want to buy a home of their own in 5 years. This might be possible because two years later, Emily will be eligible to access a trust fund left to her as an inheritance by her late grandfather. Her trust fund has $80,000 invested at an interest rate of 5%. Justify Emily’s participation in her…Caroline has just turned 22 and has begun her first job. Her first year’s salary is $60,000per year, which is paid monthly ($5,000 per month). For planning purposes:•Her future annual salary will grow at a rate of 4% per year.•She will work for 40 years and retire on her 62th birthday.•She will receive a pension payment each year for 30 years beginning on her 62thbirthday.•Accounting for inflation, her first pension payment should be $150,000.•Her pension payments should increase at a rate of 2.5% per year.•She has decided to withdraw 100p% from her monthly paycheck.•She wants to use a 6% EAR as an appropriate interest rate.What is the minimum value for p (to the nearest whole percent) to fund Caroline’s plan?Ignore taxes for this analysis.Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. A) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. B) Alteratively, how much would she have to invest in equal monthly amounts starting at the end of the current year or monthly respectively. please show work in excel as that is what i am not understanding mostly