- The total actual income for August 2022 is $10,650.00.
- The total actual expenses (Bills + Expenses) are $3,766.00 ($1,605.00 + $2,161.00).
- The total actual savings are $2,934.00.
- The total actual debts paid are $3,200.00.
- The total actual money saved (Savings + Investments) is $3,684.00 ($2,934.00 + $750.00).
- The difference between expected and actual income is +$50.00.
- The difference between expected and actual expenses is -$389.00, indicating spending was under budget.
- The difference between expected and actual savings is +$434.00, indicating more was saved than planned.
- The difference between expected and actual debts paid is +$5.00.
- The zero-based budget difference is $0.00, meaning all income has been allocated.
- The "Money In" is $10,650.00, which equals 100% of the budget.
- The "Money Out" is $3,766.00, which is 35.36% of the income.
- The "Debts Paid" is $3,200.00, which is 30.05% of the income.
- The "Money Saved" is $3,684.00, which is 34.59% of the income.
- The pie chart shows the allocation of expenses: Bills (15.1%), Expenses (20.3%), Savings (27.5%), Investments (7.0%), and Debts (30.0%).
Parent Tip: Review the logic above to help your child master the concept of free budget worksheet excel.