Question: Use the information below to prepare a balance sheet and a cash flow statement for Mr. King. Calculate his net worth and cash surplus or

Use the information below to prepare a balance sheet and a cash flow statement for Mr. King. Calculate his net worth and cash surplus or deficit. (All expenses are on monthly basis).

Monthly take-home salary from full time job, $4,230

Value of house, $325,000

Value of furniture and house content,$115,000

Home maintenance and repairs, $120

Cash in chequing account, $750

Savings account balance, $4,300

Spending on grocery, $600

Restaurant spending, $150

Lunch & parking, $200

Mortgage outstanding, $185,000

Electronic gadgets $4,500

Average monthly phone bill, $85

Monthly payment on credit card, $150

Value of 2 cars $43,520

Car loans outstanding, $21,300

Monthly Home and Auto insurance, $380

Monthly payment on car loan, $225

Average monthly income from part-timejob, $ 440

Monthly Mortgage and property taxpayment, $ 2,400

Value of car, $28,000

Gas and car maintenance, $240

Credit card balance, $8,200

Average monthly Electricity bill, $375

Monthly charitable donation, $350

Clothing purchase (monthly), $150

Value of Stock investment, $140,000

Monthly Entertainment, $250

Miscellaneous expenses $200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Lita Lopez started Biz Consulting, a new business, and completed the following transactions during its first year of operations.Lita Lopez invested $ 6 9 , 0 0 0 cash and equipment valued at $ 3 7 ,...

I need to confirm my answers. Please help ! 1. Mrs. Reznik, who 27 years old, plans to retire at the age of 55. She is expecting a lumpsum amount (an inheritance) of $75,000 when she is 40. This...

I can't figure out how to get the answer of PART C. I must show my work; therefore, I can't use Excel to find the answer of part C. Thanks UNIVERSITY OF NEW BRUNSWICK Faculty of Business...

Monthly take-home salary, $6,250 Part-time average monthly salary, $480 Value of furniture and house content, $120,000 Home maintenance and repairs, $100 Cash in chequing account, $2,500 Savings...

1.Use the information below to prepare a balance sheet and a cash flow statement for Mr. Clayton. Calculate his net worth and cash surplus or deficit. Monthly take-home salary, $6,250 Part-time...

1.Use the information below to work out balance sheet and a cash flow statement for Mr. Clayton. Calculate his net worth and cash surplus or deficit? Monthly take-home salary, $6,250 Part-time...

1. Based on the following data, compute the total assets, total liabilities, and net worth. Liquid assets, $4,670 Household assets, $93,780 Investment assets, $26,910 Long-term liabilities, $76,230...

Use the following items to prepare a balance sheet and a cash flow statement. Determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows Balance Sheet and...

What was the nature of the fraud at Equity Funding? How was the fraud covered up? What type of business analysis would have revealed the fraud?

Freight car loadings over a 12-year period at a busy port are as follows: a. Determine a linear trend line for expected freight car loadings. b. Use the trend equation to predict expected loadings...

2.Implement Verilog Code and design a test bench to show the input conditions needed to produce x = 1 in Figure below:

Show your all calculation and also good handwriting The lower bound for the eigenvalue of the -1 matrix A = 2 -4 2 3 1 -1 o 4 3 is 4

16. bne mole of monatomic ideal gas at temperature T expands from V to 2V isothermally. The change in internal energy of the gas during this expansion is (B) 0 JETRT In2 (D) RT InV (E)RT In2V A) RT...

11. The uncertainty in the velocity of particle is cqual to its velocity. If h is Planck constant and 2 is its de Broglie wavelength. The uncertainty in its location 15: (A) 2 (B) 2 (C) /4 00 (D) 0...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Define the term leverage as it applies to accounting. Appendix

Assets Liabilities Owners equity. How would you restate this equation if you wanted to know what your liabilities are? Your owners equity? Appendix

Explain the difference between macro-aging and micro-aging accounts receivable schedules. Appendix