ACCOUNTING
MathStat Genius
Case1_100AAAARRRR.xlsxNW
| NET WORTH STATEMENT | |||||||
| ASSETS | LIABILITIES | ||||||
| Cash/Cash Equivalents | Liabilities | ||||||
| Checking account | $ | 3,000 | Credit card balance | $ | 8,500 | ||
| Savings Account | 5,000 | Student Loan Debt | 30,000 | ||||
| Money Market Account | - 0 | Auto note balance | 18,000 | ||||
| Life Insurace Cash Value | 25,000 | Mortgage Balance | 250,000 | ||||
| Total Cash/Cash Equivalents | 33,000 | Total Liabilities | 306,500 | ||||
| Invested Assets | |||||||
| Brokerage Account | 15,000 | ||||||
| Business | - 0 | ||||||
| IRAs | - 0 | ||||||
| 401k or Vested Pension | 50,000 | ||||||
| Total Invested Assets | 65,000 | TOTAL LIABILITIES | 306,500 | ||||
| Use Assets | |||||||
| Residence | 320,000 | NET WORTH | 126,500 | ||||
| Automobiles | 15,000 | ||||||
| Personal property | - 0 | ||||||
| Total Use Assets | 335,000 | ||||||
| TOTAL ASSETS | 433,000 | TOTAL LIABILITIES AND NET WORTH | 433,000 | ||||
CF
| Cash Flow Statement | |||||||||||||||
| Outflows | Inflows | Totals | Cash Flow Statement 10 Years | ||||||||||||
| INFLOWS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||||
| Gross salaries | $ | 122,500 | 127,400.00 | 131,986.89 | 137,002.39 | 142,208.48 | 147,612.41 | 153,221.68 | 159,044.10 | 165,087.78 | 171,361.11 | 177,872.83 | |||
| Dividend income | 800 | 832.00 | 865.28 | 899.89 | 935.89 | 973.32 | 1,012.26 | 1,052.75 | 1,094.86 | 1,138.65 | 1,184.20 | ||||
| Interest income | 50 | 52.00 | 54.08 | 56.24 | 58.49 | 60.83 | 63.27 | 65.80 | 68.43 | 71.17 | 74.01 | ||||
| Other Income | 0 | ||||||||||||||
| TOTAL INFLOWS | $ | 123,350 | 123,350 | 128,284.00 | 133,415.36 | 138,751.97 | 144,302.05 | 150,074.14 | 156,077.10 | 162,320.18 | 168,812.99 | 175,565.51 | 182,588.13 | ||
| 128,284.00 | 132,906.25 | 137,958.53 | 143,202.86 | 148,646.56 | 154,297.20 | 160,162.64 | 166,251.06 | 172,570.93 | 179,131.04 | ||||||
| OUTFLOWS | |||||||||||||||
| Savings and Investments | $ | 11,300 | 11,752.00 | 12,222.08 | 12,710.96 | 13,219.40 | 13,748.18 | 14,298.10 | 14,870.03 | 15,464.83 | 16,083.42 | 16,726.76 | |||
| Fixed Outflows | |||||||||||||||
| Housing | $ | 20,400 | 21,216.00 | 21,810.78 | 22,552.35 | 23,319.13 | 24,111.98 | 24,931.79 | 25,779.47 | 26,655.97 | 27,562.27 | 28,499.39 | |||
| Property Taxes | 4,000 | 4,152.00 | 4,309.78 | 4,473.55 | 4,643.54 | 4,820.00 | 5,003.16 | 5,193.28 | 5,390.62 | 5,595.46 | 5,808.09 | ||||
| Student Loan Payments | 7,200 | 7,488.00 | 7,787.52 | 8,099.02 | 8,422.98 | 8,759.90 | 9,110.30 | 9,474.71 | 9,853.70 | 10,247.85 | 10,657.76 | ||||
| Auto Loan Payments | 6,000 | 6,240.00 | 6,489.60 | 6,749.18 | 7,019.15 | 7,299.92 | 7,591.91 | 7,895.59 | 8,211.41 | 8,539.87 | 8,881.47 | ||||
| Insurance premiums | 2,900 | 3,016.00 | 3,136.64 | 3,262.11 | 3,392.59 | 3,528.29 | 3,669.43 | 3,816.20 | 3,968.85 | 4,127.60 | 4,292.71 | ||||
| Total Fixed Outflows | $ | 40,500 | 42,112.00 | 43,534.32 | 45,136.21 | 46,797.39 | 48,520.09 | 50,306.58 | 52,159.25 | 54,080.55 | 56,073.06 | 58,139.41 | |||
| Variable Outflows | |||||||||||||||
| Taxes | $ | 26,950 | |||||||||||||
| Food | 8,400 | ||||||||||||||
| Transportation | 6,000 | ||||||||||||||
| Clothing/personal | 4,800 | ||||||||||||||
| Entertainment/vacation | 6,000 | ||||||||||||||
| Medical/dental care | 4,200 | ||||||||||||||
| Utilities/household | 3,000 | ||||||||||||||
| Credit card payments | 7,200 | ||||||||||||||
| Miscellaneous | 5,000 | 71,550 | |||||||||||||
| Total Variable Outflows | $ | ||||||||||||||
| TOTAL OUTFLOWS | 112,050 |
Financial Ratios
| Liquidity Ratio: | 5.37 | |
| Savings Ratio: | 9.2% | |
| Front End Ratio: | 21.8% | |
| Back End Ratio: | 30.0% | |
| Net Investment Assets to Net Worth: | 77.5% |
