Your goal is to have a college fund for your child. Suppose you find a fund that  offers an APR of 5% compounded monthly. Use Excel to create a table with  months as the first column, payment in the second column and amount in  account as the third. Use the table to determine how much should you deposit monthly to accumulate $85000 in 15 years.

Q: Henry would like to have a retirement income of $3,000 per month (month-end payments). How much must…

A: We need to use present value of ordinary annuity(payment due at end of period) formula to solve this…

Q: The parents of a 3 year old child decide they need to start saving for their child's college fund.…

A: Here, Future value (FV) = 22,000 Time period = 15 years  Interest rate = 3.5% To Find: Present value…

Q: You plan to send your first born child to College for a 4-year degree with 4 annual payments.  Your…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: Suppose you receive $500 in graduation money. You decide to put it into an account paying 5%. If you…

A: FV= [C*{(1+r)^n-1]/r] + [P*(1+r)^n] Where P= Initial deposit = $500 C= Periodic payments = $170 r=…

Q: Juanita Domingo's parents want to establish a college trust for her. They want to make 16 quarterly…

A: Present Value is the current price of future value which will be received in near future at some…

Q: Your grandmother will be gifting you $150 at the end of each month for four years while you attend…

A: Monthly gift amount = $150Year = 4Discount rate = 3.7%To find: The worth of these payments on the…

Q: Consider the two savings plans below. Compare the balances in each plan after 6 years. Which person…

A: Future Value: The worth of a current asset at some point in the future based on an estimated rate of…

Q: You deposit $10,000 into a savings account today and leave the money in the account for the next 12…

A: Future value is the value of an annuity at a future date being compounded for a period of time at an…

Q: if you deposit $500/month into a college fund with APR 4.5%, how much do you have after 18 years…

A: The future value of an ordinary annuity is the accumulated value of an equal amount of deposits made…

Q: Upon retirement, your goal is to spend 6 years traveling around the world. To travel in the style to…

A: Given Information: Periodic payment = $225,000 Rate of interest = 9% compound annually Period = 24…

Q: you for the next 6 years, with your first deposit one month from today. If your savings earn 12.05%…

A: As per the given information: Amount deposited every month = $650Period = 6 yearsInterest rate =…

Q: Assume the total cost of a university education will be $90,000 when your child enters university in…

A: Compound = Monthly = 12Future Value = fv = $90,000Time = t = 6 * 12 = 72Present Value = pv = $55,000

Q: In the case that the result is decimal, you will round it to two decimal places. 4. New…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: Nathan and Stephanie are saving for their daughter's college education. Their daughter, Paige, is…

A: The present value analysis is used to find out the profitability of a project. It uses the concept…

Q: Your retirement fund's balance is $50,000 right now. You want to retire in 30 years with $1,000,000.…

A: The topic concerns retirement planning and specifically focuses on calculating the required interest…

Q: A financial planning service offers a college savings program. The plan calls for you to make six…

A: The question is related to Return on Investment. The ROI is calculated with the help of following…

Q: Cathy wishes her daughter Aleah receive Php 100,000 ten years from now. What amount should she…

A: In this problem, first we have find present value at the end of 2 years taking time as 8 years and…

Q: Suppose you are 30 years old and would like to reure do this? Assume a constant APR of 5% and that…

A: Amount withdrawn per year = $100,000Current age = 30 yearsAPR = 5%Retirement age = 65 years

Q: 2. At the end of each year, an investor deposits some money into a fund earning 7% interest. The…

A: When the certain amount of money is deposited at the regular interval over a period of time at a…

Q: What lump sum do parents need to deposit in an account earning 11%, compounded monthly, so that it…

A: Solution:- When an amount is invested somewhere, it earns interest on it. The amount initially…

Q: retire at age 60. Furthermore, you would like to have a retirement fund from which you can draw an…

A: Future value is the amount of deposit done and plus amount of compounding interest accumulated over…

Q: How much will you have saved at the end of 6 years? Find the interest.

A: A stream of equal cash flows paid or received periodically is termed as annuity. Annuity is either…

Q: Suppose an individual wants to have $200,000 available for her child's education. Find the amount…

A: The concept of time value of money will be used here. As per the concept of time value of money any…

Q: Suppose you are 30 years old and would like to retire at age 65. Furthermore, you would like to have…

A:

Q: The Smiths are planning ahead for their daughter’s education. She’s 8 now and will start college in…

A: Future value is the estimated value of a current asset that is likely to be received at a future…

Q: Solve with lump sum. A 13-year-old has his dad save$100of his birthday money for the next family…

A: The time value of money is applied when the future value of an equated amount deposited is to be…

Q: Tara wishes to accumulate $25,000 in 3 years. use the appropriate formula to find the sinking fund…

A: Sinking Fund  A sinking fund is a specific kind of fund that is established with the intention of…

Q: A financial planning service offers a college savings program. The plan calls for you to make six…

A: Annual Payment = 14000 Time Period = 6 years Beginning of period payments   Future Value = Sum of…

Q: What lump sum do parents need to deposit in an account earning 11%, compounded monthly, so that it…

A: Given: Interest rate = 11% Future value = $90,000 Years = 16 Compounding is monthly

Q: We consider the effects of starting early or late to save for retirement. Assume that each account…

A: The future value concept can be used to determine the future value of a stream of cash flows. The…

Q: what amount should she deposit now?

A: Present Value is the value of a cash flow at the current time. The value of money multiplies with…

Q: To pay for your child’s education, you wish to have accumulated $25,000 at the end of 15 years. To…

A: Future Value refers to compounded value of present amount or a series of equal amount of payment…

Q: A student needs to borrow $7,000 to pay for college. She can get a loan at an APR of 10% to paid off…

A: We need to calculate total payment by using the loan amortization formula. Fist we need to calculate…

Q: Question - : Your child is going to college for the next 4 years. You are setting up a college fund…

A: Present value (PV) is a money related concept that measures the current value of future cash streams…

Q: u decided to take a study abroad for the Spring 2023 semester. You decided to save $200 each month…

A: Future value of annuity includes the amount being deposited and amount of compounding interest being…

Q: What lump sum do parents need to deposit in an account earning 10%, compounded monthly, so that it…

A: As per our guidelines we are supposed to answer only one question (if there are multiple questions…