Description
complete the flie below
Unformatted Attachment Preview
MONTLY BUDGET APPLICATION
INPUTS
Monthly Income
Item
Income 1
Income 2
OUTPUTS
Summary Report
Amount
Income 3
Other
Total Monthly Income
Total Monthly Expenses
Balance
3200
1500
0
150
PERCENT OF INCOME SPENT EACH MONTH
Monthly Expenses
Item
Amount
Expense Distribution
Item
% of Income
Rent/Mortgage
Rent/Mortgage
Utilities
Auto pay ment & Repear
Utilities
Auto pay ment & Repair
Groceries
Insurence
Groceries
Insurance
Student Loans & Consomer Debt
Clothing & Entertainment
Savings
Student Loans & Consumer Debt
Clothing & Entertainment
Savings
Medical / Dental
Medical / Dental
Miscellaneous
Miscellaneous
Suggested % of Income
Please refer to the PDF document in the Blackboard Assignment for activity instructions
This assignment portal also contains the ‘Income Expense Information’ Excel file needed to complete this activity
####
Each Month
$1,100.00
Rent / Mortgage
$195.45
Insurance
$495.00
Student Loans & Consumer Debt
$300.00
Savings
Utilities
Auto payment & Repair
Groceries
Clothing & Entertainment
Medical / Dental
Miscellaneous
January
$215.75
$265.00
$452.50
$195.88
$175.00
$301.81
These expenses are constant each
month.
Use 3-D cell references to link these
values to the ‘Monthly Expenses’
February
$195.68
$200.00
$379.52
$154.23
$60.00
$416.94
March
$197.23
$440.00
$415.66
$192.59
$60.00
$214.53
April
$184.55
$265.00
$435.88
$189.90
$60.00
$428.92
May
June
$219.32 $325.80
$990.00 $200.00
$429.87 $456.74
$136.41 $98.44
$60.00 $60.00
$343.11 $83.03
July
$305.86
$265.00
$408.55
$235.52
$175.00
$318.46
August September October November December Monthly Average:
$272.89
$199.48 $173.89 $217.32 $205.44
$226.10
$200.00
$690.00 $265.00 $200.00 $190.00
$347.50
$412.87
$398.23 $419.24 $502.65 $485.50
$433.10
$246.54
$131.63 $247.61 $137.21 $195.49
$180.12
$685.23
$60.00 $60.00
$60.00
$60.00
$131.27
$326.57
$364.48 $497.32 $120.31
$50.40
$288.82
Since these
an average monthly v
Insert 3
worksheet to link the
the ‘Monthly Expense
Since these expenses vary each month, we will use
an average monthly value for budget calculations.
Insert 3-D cell refrences in the ‘Monthly Budget’
worksheet to link these monthly average values to
the ‘Monthly Expenses’ expenses section of the
93992
Purchase answer to see full
attachment
