Question

PLEASE HELP IM SO LOST

1. Ted is working on his financial plan and lists all of his income and expenses in the spreadsheet below.
А
B
Net Pay
$5,000
2
Interest on Deposits $0
3 Income from Investments $225
4 Rent
$3,000
5 Utilities
$250
6 Satellite Dish
$175
7 Cell Phone Plan
$135
8 Car Payment
$385
9 Groceries
$200
10 Insurance
$380
11 Recreation
$400
What is Ted's net cash flow?
2. Tamara earns $8 an hour at her job working 25 hours per week. If her net pay is 78% of her paycheck
and she has no other sources of income, what is Tamara's monthly cash inflow? (Assume there are 4
pays per month.)

Answer 1

Ted's net cash flow is $300.

To calculate Ted's net cash flow, we need to subtract his total expenses from his total income.

In this case, Ted's total income is the sum of his net pay, interest on deposits, and income from investments:

Total Income = Net Pay + Interest on Deposits + Income from Investments

= $5,000 + $0 + $225

= $5,225

Next, we need to calculate Ted's total expenses by summing the amounts of rent, utilities, satellite dish, cell phone plan, car payment, groceries, insurance, and recreation:

Total Expenses = Rent + Utilities + Satellite Dish + Cell Phone Plan + Car Payment + Groceries + Insurance + Recreation

= $3,000 + $250 + $175 + $135 + $385 + $200 + $380 + $400

= $4,925

Finally, we can find Ted's net cash flow by subtracting his total expenses from his total income:

Net Cash Flow = Total Income - Total Expenses

= $5,225 - $4,925

= $300

Therefore, Ted's net cash flow is $300.

Answer 2

Answer: 1) $300 2) $624

Explanation:

`\begin{array}l\underline{\quad \text{Item}\qquad \qquad \qquad \qquad}&\underline{\text{Income} }&\underline{\text{Expense}}\\\text{Net Pay}&5000&\\\text{Interest on Deposits}&0&\\\text{Income from Investments}&225&\\\text{Rent}&&3000\\\text{Utilities}&&250\\\text{Satellite Dish}&&175\\\text{Cell Phone Plan}&&135\\\text{Car Payment}&&385\\\text{Groceries}&&200\\\text{Insurance}&&380\\\underline{\text{Recreation}\qquad \qquad \qquad}&\underline{\qquad \quad }&\underline{400\qquad}\\\end{array}`

TOTALS 5225 4925

Net Cash Flow = Income - Expenses

= 5225 - 4925

= 300

*************************************************************************************

`(25\ hours)/(week)* (\$8)/(hour)* 4\ weeks* 78\%\\\\\\=25* \$8 * 0.78\\\\= \$624`