In: Accounting
Diana is saving for her education. She will deposit some money into a savings account today and in addition, deposit $500 per month for the next 2 years (24 deposits) starting one month from now. Her goal is to have enough money in the account so that she can withdraw $3,000 per month for 4 years (48 withdrawals) while she attends college and still have $8,000 left at the end for a trip to South America to celebrate her graduation. Her first withdrawal will be exactly 2 years from now when she starts college. Assume the account earns 3% compounded monthly during the entire 6 years.
How much does Diana need to deposit today? ANSWER: (in 2 decimal places),
To solve this problem, you will be creating a table with the following format.
B/E |
P/Y |
C/Y |
N |
I/Y |
PV |
PMT |
FV |
A=? |
|||||||
B=? |
C=? |
Type the value of A below.
Type the value of B below.
Type the value of C below.
Month | 72 | Intt rate = | 0.25 | 100.25 | ||
Month End | End balance | Withdrawal | Deposit in Current Month | Net = deposit - withdrawal | Interest | Opening value |
73 | 8000.0 | 0 | 0 | 19.95 | 7980.05 | |
72 | 7980.0 | 3000 | 0 | -3000 | 27.38 | 10952.67 |
71 | 10952.7 | 3000 | 0 | -3000 | 34.79 | 13917.87 |
70 | 13917.9 | 3000 | 0 | -3000 | 42.19 | 16875.68 |
69 | 16875.7 | 3000 | 0 | -3000 | 49.57 | 19826.12 |
68 | 19826.1 | 3000 | 0 | -3000 | 56.92 | 22769.20 |
67 | 22769.2 | 3000 | 0 | -3000 | 64.26 | 25704.93 |
66 | 25704.9 | 3000 | 0 | -3000 | 71.58 | 28633.35 |
65 | 28633.4 | 3000 | 0 | -3000 | 78.89 | 31554.46 |
64 | 31554.5 | 3000 | 0 | -3000 | 86.17 | 34468.29 |
63 | 34468.3 | 3000 | 0 | -3000 | 93.44 | 37374.86 |
62 | 37374.9 | 3000 | 0 | -3000 | 100.69 | 40274.17 |
61 | 40274.2 | 3000 | 0 | -3000 | 107.92 | 43166.26 |
60 | 43166.3 | 3000 | 0 | -3000 | 115.13 | 46051.13 |
59 | 46051.1 | 3000 | 0 | -3000 | 122.32 | 48928.81 |
58 | 48928.8 | 3000 | 0 | -3000 | 129.50 | 51799.31 |
57 | 51799.3 | 3000 | 0 | -3000 | 136.66 | 54662.65 |
56 | 54662.7 | 3000 | 0 | -3000 | 143.80 | 57518.85 |
55 | 57518.9 | 3000 | 0 | -3000 | 150.92 | 60367.93 |
54 | 60367.9 | 3000 | 0 | -3000 | 158.02 | 63209.91 |
53 | 63209.9 | 3000 | 0 | -3000 | 165.11 | 66044.80 |
52 | 66044.8 | 3000 | 0 | -3000 | 172.18 | 68872.62 |
51 | 68872.6 | 3000 | 0 | -3000 | 179.23 | 71693.38 |
50 | 71693.4 | 3000 | 0 | -3000 | 186.27 | 74507.11 |
49 | 74507.1 | 3000 | 0 | -3000 | 193.28 | 77313.83 |
48 | 77313.8 | 3000 | 0 | -3000 | 200.28 | 80113.55 |
47 | 80113.5 | 3000 | 0 | -3000 | 207.27 | 82906.28 |
46 | 82906.3 | 3000 | 0 | -3000 | 214.23 | 85692.05 |
45 | 85692.0 | 3000 | 0 | -3000 | 221.18 | 88470.87 |
44 | 88470.9 | 3000 | 0 | -3000 | 228.11 | 91242.77 |
43 | 91242.8 | 3000 | 0 | -3000 | 235.02 | 94007.75 |
42 | 94007.7 | 3000 | 0 | -3000 | 241.91 | 96765.83 |
41 | 96765.8 | 3000 | 0 | -3000 | 248.79 | 99517.04 |
40 | 99517.0 | 3000 | 0 | -3000 | 255.65 | 102261.39 |
39 | 102261.4 | 3000 | 0 | -3000 | 262.50 | 104998.89 |
38 | 104998.9 | 3000 | 0 | -3000 | 269.32 | 107729.56 |
37 | 107729.6 | 3000 | 0 | -3000 | 276.13 | 110453.43 |
36 | 110453.4 | 3000 | 0 | -3000 | 282.93 | 113170.50 |
35 | 113170.5 | 3000 | 0 | -3000 | 289.70 | 115880.80 |
34 | 115880.8 | 3000 | 0 | -3000 | 296.46 | 118584.34 |
33 | 118584.3 | 3000 | 0 | -3000 | 303.20 | 121281.14 |
32 | 121281.1 | 3000 | 0 | -3000 | 309.93 | 123971.21 |
31 | 123971.2 | 3000 | 0 | -3000 | 316.64 | 126654.57 |
30 | 126654.6 | 3000 | 0 | -3000 | 323.33 | 129331.25 |
29 | 129331.2 | 3000 | 0 | -3000 | 330.00 | 132001.24 |
28 | 132001.2 | 3000 | 0 | -3000 | 336.66 | 134664.58 |
27 | 134664.6 | 3000 | 0 | -3000 | 343.30 | 137321.28 |
26 | 137321.3 | 3000 | 0 | -3000 | 349.93 | 139971.35 |
25 | 139971.4 | 3000 | 0 | -3000 | 356.54 | 142614.81 |
24 | 142614.8 | 500 | 500 | 356.54 | 141758.28 | |
23 | 141758.3 | 500 | 500 | 353.51 | 141404.76 | |
22 | 141404.8 |
Related SolutionsHow much money does Mandy need to deposit into her investment account today if she wishes...How much money does Mandy need to deposit into her investment
account today if she wishes to withdraw $80,000 a year for 20
years, starting at the end of the year? She expects to earn an
average rate of return of 10 percent. $703,287.38 $681,085.10
$904,298.28 $805,298.40
How much money does Suzie need to have in her retirement savings account today if she...How much money does Suzie need to have in her retirement savings
account today if she wishes to withdraw $42,000 a year for 25
years? She expects to earn an average rate of return of 9.55
percent.
Group of answer choices
$394,819.18
$407,419.81
$385,160.98
$390,202.69
$388,683.83
Brian and Felicia deposit money into separate savings accounts today. Brian deposits X into his account,...Brian and Felicia deposit money into separate savings accounts
today. Brian deposits X into his account, while Felicia deposits
(x/2) . Brian's account earns simple interest at an annual rate of
j > 0. Felicia's account earns interest at a nominal annual rate
of j, compounded quarterly. Brian and Felicia earn the same amount
of interest during the last quarter of the 4th year. Calculate
j.
Julie and Ron deposit money into separate savings accounts today. Julie deposits X into his account,...Julie and Ron deposit money into separate savings accounts
today. Julie deposits X into his account, while Ron deposits X/2 .
Julie’s account earns simple interest at an annual rate of j >
0. Ron's account earns interest at a nominal annual rate of j,
compounded quarterly. Julie and Ron earn the same amount of
interest during the last quarter of the 4th year. Calculate j.
Jamal and Nora are interested in saving money for their son's education. Today is their son's...Jamal and Nora are interested in saving money for their son's
education. Today is their
son's 8th birthday. Their son will enter college ten years from now
on his 18th birthday,
and will attend college for four years. All college costs are due
at the beginning of the
year, so the couple will have to make payments on their son's 18th,
19th, 20th and 21st
birthdays (t = 10, 11, 12, 13). They estimate that the college
their son wants...
John starts a savings account by depositing $1,000 today and thenincreases the deposit by $50...John starts a savings account by depositing $1,000 today and then
increases the deposit by $50 each year until Year 20. If the bank
pays an interest of 12% per year compounded yearly, what is the
account balance at the end of 25 years?
A friend wants to deposit $2000 into a savings account. She goes to two banks and...A friend wants to deposit $2000 into a savings account. She goes
to two banks and is offered competing interest rates for the
account. Bank 1 has a 10% interest rate, and compounds once
annually. Bank 2 has an 9% interest rate, but compounds monthly.
Use the following annually compounded interest formula,
A=P(1+r)^t
where A is the accumulated amount, P is the principal amount
deposited, r is the annual interest rate (as a decimal) and t is
the number of...
Today, you open a new savings account and deposit $3,000. No other deposits or withdrawals are...Today, you open a new savings account and deposit $3,000. No
other deposits or withdrawals are made to your account. Assume you
will earn 4% simple interest per year. How much will your
investment be worth in 25 years?
Today, you open a new savings account and deposit $3,000. No other deposits or withdrawals are...Today, you open a new savings account and deposit $3,000. No
other deposits or withdrawals are made to your account. Assume you
will earn 4% simple interest per year. How much will your
investment be worth in 25 years
Today, you open a new savings account and deposit $3,000. No other deposits or withdrawals are...Today, you open a new savings account and deposit $3,000. No
other deposits or withdrawals are made to your account. Assume you
will earn 4% simple interest per year. How much will your
investment be worth in 25 years?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|