This template is prepared for observing how cutting small expenses may effect one's budget in long term. 22 expense common expense items are displayed on the sheet. However, this items may be edited by the user. The user enters the prices of these items and the frequencies that the items are purchased. These data is used for calculating the total expense in the current situation. Then, possible give up frequencies of these items are entered (give up one cup of coffee a day). This data is used for calculating total savings by giving up the item in the selected frequency. Yearly totals of expense items and possible savings are calculated. Finally, using a given interest rate, cumulative savings at a given target age is calculated in order to understand the impact of savings in long term.
SAVINGS BY CUTTING DAILY EXPENSES Expense Item Cup of Coffee Breakfast out Dinner out Lunch out Taxi Bus Ticket Newspaper Bottled Water Gossip Magazine Shopping Magazine Sports Magazine Movies DVD Rental Hair Care Manicure Pack of Cigarettes Pack of Beer Cleaner New Shoes Gym Membership New Plasma TV New Laptop 2 1 5 3 1 10 1 Regular Frequency Unit Price times a day 1.00 times a week 5.00 times a month 40.00 times a week 10.00 times a week 35.00 times a week 2.00 times … times a day 1.00 times … times … times … times a month 15.00 times a month 10.00 times … times … times … times … times … times in 3 months 75.00 times … times in 3 years 2,500.00 times … TOTAL YEARLY EXPENSES: Yearly Total 730.00 260.00 2,400.00 1,560.00 1,820.00 1,040.00 365.00 4 1 720.00 120.00 1 1 300.00 833.33 10,148.33 ANALYSIS Your Age: Target Age: Est'd Annual Interest Rate: 30 60 5% By saving about 33% of your expenses every yea At the age of 60, growth of your savings could re G DAILY EXPENSES Yearly Total 730.00 260.00 2,400.00 1,560.00 1,820.00 1,040.00 365.00 1 1 1 1 Give up Frequency times a day times … times a month times a week times a week times … times … times … times … times … times … times … times a month times … times … times … times … times … times a year times … times … times … TOTAL YEARLY SAVI
Pages to are hidden for
"Savings by Cutting Expenses - Excel"Please download to view full document