FAU ISM3011 assignment 1

ASSIGNMENT # 1 (3% OF GRADE)

Your assignment is to develop a financial budget workbook for 2012. The worksheets should be titled properly. You can use made up data in lieu of your actual finances to protect your privacy.

For each month, indicate your projected income and expenses, by type. Calculate your total income, expenses and projected savings.(20 pts)

Calculate your cash flow by subtracting your monthly expenses from your income and adding the result to the previous monthly results.( 20 pts)

Calculate your total income, expenses and savings for the entire year.(20 pts)

Develop a line Sparkline for savings, showing how it changes throughout the year.(10 pts)

Develop a pie chart comparing yearly expenses by type with the total yearly dollar amount for each expense and place on a separate worksheet.( 10 pts)

If you decide to buy a car, how much payment per month can you afford?(10pts)

Name and save the file (yourname PBW) and upload the file.(10 pts)