Cash flow statement is attached at the bottom.

We will now start developing an understanding of some financial issues that surviving family members may face, when a breadwinner dies. In this assignment, you will prepare a cash flow statement for the scenario where Kwame died unexpectedly. For the purposes of this assignment, let$$s make the following assumptions:

$1.$ Laticia delivers a healthy baby.

$2.$ Kwame dies unexpectedly, and Laticia is raising the child as a single mother.

$3.$ Laticia goes back to work and makes the same amount of money she was making before her maternity leave

a$)$ Ignore the Balance Sheet tab $$ in this assignment, you$$ll only be working in the $$Cash Flows$$ table.

b$)$ Leave the base scenario annual and monthly cash flow columns in place, for reference. Copy those columns, paste them into the next two available columns on the right.

c$)$ Title both scenarios something like $$Base case$$ and $$If Kwame dies$.$

d$)$ Go through each income and expense item and modify those that will likely change under this new scenario.

To do this assignment well, it helps to think this through from the point of view of the surviving spouse. Imagine yourself in Laticia$$s position, and think what each line on your family$$s list of income and expenses would look like, if Kwame were to die. Which amounts would go lower or higher? Which ones would appear or disappear entirely?

For the cash flows that will change $($e$.$g$.,$ babysitter cost and other child$-$related expenses$),$ do some research online as to how much that can cost in NYC$,$ where Kwame and Laticia live. Make some reasonable assumptions about those costs $$ there is going to be a range of reasonable realistic amounts, not just one correct amount for each line.

After you research and modify each component of income and expenses, see how the bottom line number $($the cash flow surplus$)$ looks in the scenario where Kwame died, compared to the base scenario.

To complete this assignment, please do BOTH of the following:

Enter your bottomline amount $($Laticia$$s cash flow surplus or deficit$)$

Adeyemi CASH FLOW STATEMENT

Annually Monthly

Inflows

Kwame$$s salary $$475,000$ $$39,583$

Laticia's salary $$113,500$ $$9,458$

Kwame's money market account interest $$336$ $$28$

Laticia's Pfizer $401($k$)$ employer match $$4,000$ $$333$

Total Inflows $$592,836$ $$49,403$

Outflows

Child care $($babysitter$,$ baby formula, clothing, diapers etc.$)$ $$-$ $$-$

Mortgage $($principal and interest$)$ $$35,676$ $$2,973$

Apartment maintenance $$8,400$ $$700$

Real estate taxes $$7,056$ $$588$

Homeowner$$s insurance premiums $$900$ $$75$

Groceries $$2,400$ $$200$

Restaurants $$45-$$$60$ x $6$ days a week $$16,380$ $$1,365$

Utilities $$3,240$ $$270$

Clothing $$3,000$ $$250$

Transportation $$3,600$ $$300$

Entertainment $$1,200$ $$100$

Miscellaneous $$12,000$ $$1,000$

Vacation $$5,000$ $$417$

Charitable donations $$8,400$ $$700$

Federal income taxes $$124,463$ $$10,372$

New York State and City income taxes $$46,000$ $$3,833$

Social Security taxes $$17,490$ $$1,458$

Medicare taxes $$11,379$ $$948$

Kwame's student loan payment $$36,108$ $$3,009$

Laticia's student loan payment $$12,096$ $$1,008$

Kwame's Union dues $$7,600$ $$633$

Health insurance premiums $$4,940$ $$412$

Kwame$$s NYC DCP $457$ plan contributions $($maxing out Traditional$)$ $$23,000$ $$1,917$

Kwame$$s NYC DCP $401($k$)$ contributions $$-$ $$-$

Laticia's Pfizer Roth $401($k$)$ contributions $$4,000$ $$333$

Laticia's $401($k$)$ employer match $($Traditional$)$ $$4,000$ $$333$

Total Outflows $$398,328$ $$33,194$

CASH FLOW SURPLUS $$194,508$ $$16,209$