Since no specific question was asked in the prompt, but the image shows an expense tracker with a "Deductible" column that is calculated based on "Expense Amount" and "Used for Work" percentage, I will assume the task is to
verify or calculate the deductible amounts shown in the spreadsheet — specifically, to check if the values in column G (“Deductible”) are correctly calculated from columns E (“Expense Amount”) and F (“Used for Work”).
Let’s go row by row and verify each calculation:
---
Row 2:
- Expense Amount (E2): $295.64
- Used for Work (F2): 100% → 1.00
- Deductible = 295.64 × 1.00 =
$295.64 ✔ Matches G2
Row 3:
- E3: $78.54
- F3: 20% → 0.20
- Deductible = 78.54 × 0.20 =
$15.708 → rounded to
$15.71 ✔ Matches G3
Row 4:
- E4: $27.64
- F4: 100% → 1.00
- Deductible = 27.64 × 1.00 =
$27.64 ✔ Matches G4
Row 5:
- E5: $2,150.00
- F5: 10% → 0.10
- Deductible = 2150.00 × 0.10 =
$215.00 ✔ Matches G5
Row 6:
- E6: $635.04
- F6: 100% → 1.00
- Deductible = 635.04 × 1.00 =
$635.04 ✔ Matches G6
Row 7:
- E7: $24.35
- F7: 100% → 1.00
- Deductible = 24.35 × 1.00 =
$24.35 ✔ Matches G7
Row 8:
- E8: $172.92
- F8: 100% → 1.00
- Deductible = 172.92 × 1.00 =
$172.92 ✔ Matches G8
Row 9:
- E9: $92.50
- F9: 5% → 0.05
- Deductible = 92.50 × 0.05 =
$4.625 → rounded to
$4.63 ✔ Matches G9
Row 10:
- E10: $10.00
- F10: 100% → 1.00
- Deductible = 10.00 × 1.00 =
$10.00 ✔ Matches G10
Row 11:
- E11: $311.05
- F11: 100% → 1.00
- Deductible = 311.05 × 1.00 =
$311.05 ✔ Matches G11
Row 12:
- E12: $592.92
- F12: 100% → 1.00
- Deductible = 592.92 × 1.00 =
$592.92 ✔ Matches G12
Row 13:
- E13: $24.59
- F13: 5% → 0.05
- Deductible = 24.59 × 0.05 =
$1.2295 → rounded to
$1.23 ✔ Matches G13
Row 14:
- E14: $32.52
- F14: 100% → 1.00
- Deductible = 32.52 × 1.00 =
$32.52 ✔ Matches G14
---
✔ All deductible amounts in column G are correctly calculated as:
Deductible = Expense Amount × (Used for Work %)
and properly rounded to two decimal places (cents).
Final Answer:
All deductible values in the spreadsheet are correctly calculated.
Parent Tip: Review the logic above to help your child master the concept of income and expenses worksheet.