Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A document that includes 6 months of budgeted cash inflows and outflows. This must be done using 6 columns (one for each month) in an

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
A document that includes 6 months of budgeted cash inflows and outflows. This must be done using 6 columns (one for each month) in an excel spreadsheet. Please format your 6-column budget so that the width of all columns fits on one page and you must make your budget the first page of your document.
on living at home after school you must still include rent in your budget. The point of this exercise is to try and show you what life will be like when you truly become financially independent). 5. You have a credit limit of $2,000 on your only credit card, with a 2%/month APR (simple interest). The minimum monthly credit card payment is 3% of the previous month's balance, interest included. You may pay the balance in full each month, but you don't have to. If you didn't use the card, you owe nothing. You also don't have to use the credit card at all - it's just an option. 6. Because you are financially independent you will not borrow money from friends or family. You may include however; any realistic gifts you think you may receive for your birthday and/or holidays you observe where gifts may be given. 7. Acquire at least 7 of the 10 items in the box below. You can obtain these items in any legal way you choose, except you cannot be "given" any of them. To support your purchase costs for these items, please provide a calculation/price quote or online/printed ad supporting your budgeted/proposed purchase price, separately in your project. Hyperlinks will not be accepted as support. If you already own many of the items below, you need to determine at least 7 items that you will need to purchase during the budget period as a result of moving into your own place and starting your life and include those purchases in your budget. Casual Clothes Couch or Comfy and Shoes Chair TV Work Clothing and Shoes Cleaning Supplies and Vacuum Chest of Drawers or Desk Bed Frame, Box Kitchen Table Spring and and Chairs Mattress Computer and Desk or Laptop Dishes, Cutlery, Pots and Pans 8. Also include the following items in your monthly budget: a. Cell phone. b. Cable/Netflix and Internet (if not already included with rent or utilities above.) c. Food: All food, wherever you eat it. Please do not use any online estimates/food guides to come up with your budgeted monthly food expenditures. Use your own current food costs and extrapolate (i.e., you may eat more (or more expensive food) once you have a job. You may also go to more restaurants than you do now.) d. Entertainment: Consider a wide variety of entertainment, including movies, sporting e. Insurance: Renters, health, other (as you deem appropriate) f. If you choose not to have a car, budget for other modes of transportation (transit pass, Uber, Taxis, etc.) g. Medical Expenses: Consider prescriptions and co-pays for doctor visits, chiropractor, massage, physio, etc. h. If you have student loans, include a reasonable monthly repayment based on your best estimate. If your student loans have a grace period, ignore that and pretend you will be paying them immediately. If you do not have student loans, include this as $0 so I know you have not forgotten it. i. Emergency fund j. Savings (you decide what for. e.g., vacation, Christmas, large purchase, etc.) k. Retirement Contributions. These are separate from savings, since they are for the distant future. 1. Charitable contributions. You have discretion on the amount and frequency, but consider them. If you choose not to make charitable contributions, then indicate that. I would otherwise think you had omitted it unintentionally. m. Gifts for others. You have discretion on the amount and frequency, but consider them. If you don't want to spend money on a particular item listed above (e.g. savings) you must include it as $0 so I know you have not forgotten it. here are many other items you will incur in your real (hair cuts, salon Visits, tolls, parking fees, dry-cleaning, gym membership) and I will be looking for at least three additional items beyond the ones listed above. You are responsible for determining what these are. 10. Car: If you have a car or will be given a car when you graduate you need to include all associated costs in your budget. These include any financing/lease payments, gas, maintenance, insurance, parking, etc. If you don't own a car and don't plan on having one then say so in your assignment but be sure to include other appropriate transportation costs (mass transit, taxis, uber, etc.). EVERYONE, whether you own a car or not, has to research what car you would buy/lease on January 1 if you HAD to get a car and had no other choice. The purpose of this is to get you to see how buying/leasing a car impacts your budget! You need to figure out what actual car you will acquire. New/Used? Lease/Buy? Then you need to figure out the impact on your monthly budget. You do NOT need to go back and adjust your budget for this requirement. You simply need to write a few sentences to explain HOW you would change your budget if you HAD to include these expenses. For example, say you now needed to come up with $600/month to cover the cost of having a car. HOW would you adjust your budget to do that? Requirements and Deliverables: 1. A document that includes 6 months of budgeted cash inflows and outflows. This must be done using 6 columns (one for each month) in an excel spreadsheet. Please format your 6-column budget so that the width of all columns fits on one page and you must make your budget the first page of your document. I have provided an example to assist you. on living at home after school you must still include rent in your budget. The point of this exercise is to try and show you what life will be like when you truly become financially independent). 5. You have a credit limit of $2,000 on your only credit card, with a 2%/month APR (simple interest). The minimum monthly credit card payment is 3% of the previous month's balance, interest included. You may pay the balance in full each month, but you don't have to. If you didn't use the card, you owe nothing. You also don't have to use the credit card at all - it's just an option. 6. Because you are financially independent you will not borrow money from friends or family. You may include however; any realistic gifts you think you may receive for your birthday and/or holidays you observe where gifts may be given. 7. Acquire at least 7 of the 10 items in the box below. You can obtain these items in any legal way you choose, except you cannot be "given" any of them. To support your purchase costs for these items, please provide a calculation/price quote or online/printed ad supporting your budgeted/proposed purchase price, separately in your project. Hyperlinks will not be accepted as support. If you already own many of the items below, you need to determine at least 7 items that you will need to purchase during the budget period as a result of moving into your own place and starting your life and include those purchases in your budget. Casual Clothes Couch or Comfy and Shoes Chair TV Work Clothing and Shoes Cleaning Supplies and Vacuum Chest of Drawers or Desk Bed Frame, Box Kitchen Table Spring and and Chairs Mattress Computer and Desk or Laptop Dishes, Cutlery, Pots and Pans 8. Also include the following items in your monthly budget: a. Cell phone. b. Cable/Netflix and Internet (if not already included with rent or utilities above.) c. Food: All food, wherever you eat it. Please do not use any online estimates/food guides to come up with your budgeted monthly food expenditures. Use your own current food costs and extrapolate (i.e., you may eat more (or more expensive food) once you have a job. You may also go to more restaurants than you do now.) d. Entertainment: Consider a wide variety of entertainment, including movies, sporting e. Insurance: Renters, health, other (as you deem appropriate) f. If you choose not to have a car, budget for other modes of transportation (transit pass, Uber, Taxis, etc.) g. Medical Expenses: Consider prescriptions and co-pays for doctor visits, chiropractor, massage, physio, etc. h. If you have student loans, include a reasonable monthly repayment based on your best estimate. If your student loans have a grace period, ignore that and pretend you will be paying them immediately. If you do not have student loans, include this as $0 so I know you have not forgotten it. i. Emergency fund j. Savings (you decide what for. e.g., vacation, Christmas, large purchase, etc.) k. Retirement Contributions. These are separate from savings, since they are for the distant future. 1. Charitable contributions. You have discretion on the amount and frequency, but consider them. If you choose not to make charitable contributions, then indicate that. I would otherwise think you had omitted it unintentionally. m. Gifts for others. You have discretion on the amount and frequency, but consider them. If you don't want to spend money on a particular item listed above (e.g. savings) you must include it as $0 so I know you have not forgotten it. here are many other items you will incur in your real (hair cuts, salon Visits, tolls, parking fees, dry-cleaning, gym membership) and I will be looking for at least three additional items beyond the ones listed above. You are responsible for determining what these are. 10. Car: If you have a car or will be given a car when you graduate you need to include all associated costs in your budget. These include any financing/lease payments, gas, maintenance, insurance, parking, etc. If you don't own a car and don't plan on having one then say so in your assignment but be sure to include other appropriate transportation costs (mass transit, taxis, uber, etc.). EVERYONE, whether you own a car or not, has to research what car you would buy/lease on January 1 if you HAD to get a car and had no other choice. The purpose of this is to get you to see how buying/leasing a car impacts your budget! You need to figure out what actual car you will acquire. New/Used? Lease/Buy? Then you need to figure out the impact on your monthly budget. You do NOT need to go back and adjust your budget for this requirement. You simply need to write a few sentences to explain HOW you would change your budget if you HAD to include these expenses. For example, say you now needed to come up with $600/month to cover the cost of having a car. HOW would you adjust your budget to do that? Requirements and Deliverables: 1. A document that includes 6 months of budgeted cash inflows and outflows. This must be done using 6 columns (one for each month) in an excel spreadsheet. Please format your 6-column budget so that the width of all columns fits on one page and you must make your budget the first page of your document. I have provided an example to assist you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Business Finance

Authors: Michael Connolly

1st Edition

0415701538, 9780415701532

More Books

Students also viewed these Finance questions

Question

What is the trade feedback effect? AppendixLO1

Answered: 1 week ago