1)TABLE SHOWING EXPENSES
| week 1 | week 2 | week 3 | week 4 | |
| electricity | € 15.00 | € 19.00 | € 20.00 | € 20.00 |
| food | € 20.00 | € 30.00 | € 28.00 | € 23.00 |
| water | € 10.00 | € 7.00 | € 3.00 | € 8.00 |
| transport | € 30.00 | € 30.00 | € 30.00 | € 30.00 |
| shopping | € 15.00 | € 14.00 | € 7.00 | € 18.00 |
| gifts | € 10.00 | € 12.00 | € 1.00 | |
| TOTAL | € 100.00 | € 100.00 | € 100.00 | € 100.00 |
2) MONTHLY EXPENSE ACCOUNT
| week 1 | week 2 | week 3 | week 4 | |
| electricity | € 10.00 | € 18.00 | € 20.00 | € 21.00 |
| food | € 20.00 | € 25.00 | € 24.00 | € 20.00 |
| water | € 10.00 | € 7.00 | € 3.00 | € 8.00 |
| transport | € 30.00 | € 30.00 | € 27.00 | € 25.00 |
| shopping | € 10.00 | € 10.00 | € 7.00 | € 16.00 |
| gifts | € 10.00 | € 9.00 | ||
| TOTAL | € 90.00 | € 90.00 | € 90.00 | € 90.00 |
| SAVINGS | € 10.00 | € 10.00 | € 10.00 | € 10.00 |
monthly savings is € 40.00
Lets assume monthly interest to be 1%.
MONTHLY SAVINGS ACCOUNT for 1 year 6 months.
| month | monthly deposit at the beginning of month | monthly saving at the end of month | interest at the end of month on deposit |
| 1 | € 40.00 | ||
| 2 | € 40.00 | 40 | € 0.40 |
| 3 | € 80.40 | 40 | € 0.80 |
| 4 | € 121.20 | 40 | € 1.21 |
| 5 | € 162.42 | 40 | € 1.62 |
| 6 | € 204.04 | 40 | € 2.04 |
| 7 | € 246.08 | 40 | € 2.46 |
| 8 | € 288.54 | 40 | € 2.89 |
| 9 | € 331.43 | 40 | € 3.31 |
| 10 | € 374.74 | 40 | € 3.75 |
| 11 | € 418.49 | 40 | € 4.18 |
| 12 | € 462.67 | 40 | € 4.63 |
| 13 | € 507.30 | 40 | € 5.07 |
| 14 | € 552.37 | 40 | € 5.52 |
| 15 | € 597.90 | 40 | € 5.98 |
| 16 | € 643.88 | 40 | € 6.44 |
| 17 | € 690.31 | 40 | € 6.90 |
| 18 | € 737.22 | 40 | € 7.37 |
| amount after 1 yr 6 months | € 784.59 |
You have £100 weekly for expenses paid monthly in advance on the first day of the...
You have £100 weekly for expenses paid monthly in advance on the
first day of the month (assume 4 week month). Give a breakdown of
these weekly expenses.
1. Create a one month spreadsheet (spreadsheet 1) by week
assuming all expenses are paid in full on the last day of the month
and no money remains in your account.
2. Consider whether you are able to make any savings and assume
these savings are constant each month. Suppose you invest...
show the work on financial
calculator
On the first day of the month an investor places $300 into a savings account. The investor places $200 into the savings account on the last day of the same month. The investor continues to place $200 into the savings account on the last day of each subsequent month for a period of three years. The savings account offers 6% interest per year, compounded monthly. After three years, how much money will be in...
4. You have just paid your subscription to Investing Wisely Weekly through the end of this year. You plan to subscribe to the magazine for the rest of your life. You have two options. You can either renew the subscription annually by paying $85 at the end of each year or you can get a lifetime subscription for $620 payable immediately. Assuming that you can earn 6.0% on your funds and that the annual renewal rate will remain constant, how...
A) How much money will be in your savings account on January 1, 2023 if you deposit $5,000 on January 1, 2020 and you earn 3.1% per year in interest? Interest is compounded annually on December 31 B) How much money would you have to deposit on January 1, 2020 to have $5,000 in your bank account on January 1, 2027 if the savings account paid 1.25% interest, compounded annually on December 31 of each year? C) Suppose your discount...
You plan to buy the house of your dreams in 8 years. You have estimated that the price of the house will be $88,195 at that time. You are able to make equal deposits every month at the end of the month into a savings account at an annual rate of 11.47 percent, compounded monthly. How much money should you place in this savings account every month in order to accumulate the required amount to buy the house of your...
Suppose you invest $120 a month for 8 years into an account earning 9% compounded monthly. After 8 years, you leave the money, without making additional deposits, in the account for another 21 years. How much will you have in the end? Suppose instead you didn't invest anything for the first 8 years, then deposited $120 a month for 21 years into an account earning 9% compounded monthly. How much will you have in the end? Get help: Video
You plan to buy the house of your dreams in 18 years. You have estimated that the price of the house will be $115,506 at that time. You are able to make equal deposits every month at the end of the month into a savings account at an annual rate of 4.17 percent, compounded monthly. How much money should you place in this savings account every month in order to accumulate the required amount to buy the house of your...
How many months do you need to work to have enough money to retire? Assume you want $1,000,000 to retire, you currently do not have any savings, but starting next month, you will be able to make monthly deposits of $500 into your retirement account that returns on average 5.5% per year compounded monthly. Question 18 options: 507 months 88 months 1056 months 782 months
12. While in college, Howard ivests $100 on the first day of each month begiing in August. Suppose that the account pays 0.7% interest per month. On May 15th of the fourth year, Howard graduates and withdraws all of the money, closing the account. You may assume that May 15th is at exactly 1/2 of a month (a) Write a geometric expression for the accumulated value of Howard's account at the time of withdrawal. (b) Calculate the amount of money...
You buy a new home for $500,000 on the first day of the month. You put down $50,000 and finance the rest with a mortgage at 6% annual interest compounded monthly on the last day of the month. Your monthly payments including principal and interest are 2500. Your payments are due on the first day of the month, starting next month. What is your loan balance after your third monthly payment ? explain how you got the answer !