f

Fill in the yellow blanks and show me how you figured out the ratios. Use the Goals numbers to help

Worksheet 5 - Simplified Income Statement Worksheet Your Take-Home Pay Total Income 50000 Total Income Taxes 10000 - 5000 Total Savings Expense Net Income = 35000 Your Living Expenses 10000 200 250 500 Total Housing Expenditures + Total Food Expenditures + Total Clothing and Personal Care Expenditures + Total Transportation Expenc + Total Recreation Expenditur + Total Medical Expenditures + Total Insurance Expenditure + Total Other Expenditures + Total Living Expenditures (add lines D through K) 15000 20000 150 = 46100 -11100 Income ND Expenses Car Payments Total PITI PITI Debt 4167 Credit Payments School Payments Mortgage / Rent Food Utilities 300 400 1500 795 200 120 3315 U17 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Clipboard A X fx B D E F Balance Sheet - Calculating Your Net Worth Assets Value Cash $500 + $5,000 Checking Savings/CDs + $12,000 Money Market Funds + Other Monetary Assets + Monetary A A. A. $17,500 Mutual Funds Stocks + CD + $5,000 Life Insurance (cash-va + Cash Value of Annuitie + Investment Real Estate + Other investments Investment + B. B. = $5,000 401(k) and 403(b) Company Pension Keogh + + IRA + Other Retirement Plans C. Retirement C. = $0 Primary Residence + 2nd Home Time-Shares/Condomi + + Other Housing Housing (m D. D. = $0 Automobile 1 Automobile 2 Other Automobiles E. Automobile E. = $0 Collectibles Boats Furniture Other Personal Propert + Personal Pr F. F. = $0 Money Owed You + Market Value of Your B Other G. Other Asse G. = $0 H. Total Asset H. = $22,500 +++ G H I J Number K L M N 0 P Balance Sheet - Calculating Your Net Worth (continued) Liabilities or Debts Value I. Current Bill I. = $12,000 Visa Master Card + Other Credit Cards J. Credit Card J. = $12,000 + First Mortgage 2nd Home Mortgage Home Equity Loan Other Housing Debt Housing K. + K. $0 Automobile 1 Automobile 2 + Other Automobile Loar Automobile L. L. = $0 College Loans $2,000 Loans on Life Insuranc Bank Loans + Installment Loans Other + M. Other Debt $2,000 N. Total Debt $14,000 Net Worth H. Total Asset $22,500 N. Less: Total $14,000 O. Equals: Net $8,500 M. N. H. N. 0. + = Q R Styles S T U V 4167 nts ents ments Rent W X Cens 300 400 1500 795 200 120 3315 Y Z B8 36%-(M PITI + M Debt Payment)/Gross M Income B D 1 2 Ratio Formula Calculation Comments Monetary Assets/ This number means I could pay off my credit 1.46 and still have money left over. 3 Current Current Liabilities 4 Monetary Assests/ Non Discretionary This number is strong since our goal for an 5 Emergency Expense 5.279034691 emergency fund should provide 5-8 months. 6 28%- M-Piti/M 7 HR1 Income 36%-(M PITI + M Debt Payment)/Gross M 8 HR2 Income 9 Total Savings Contributions/Total 10 Saving Ratior Income 10.00% 11 12 13 MORTAGE ----> Total Monthly Payment for your house 14 PITI- Principle, Interest, Taxes, and Insurance 15 16 17 A E DESIRED ACHIEVEMENT PRIORITY LEVEL DATE 1st 12/20/2022 2nd 3/4/2023 4th 5/4/2023 3rd 1/4/2023 Intermediate-Term Goals (1 to 10 years) 2nd 1/4/2027 1st 1/4/2026 3rd 1/4/2030 4th 6/14/2032 Long-Term Goals (greater than 10 years) 1st 2/4/2034 3rd 3/4/2038 2nd 6/4/2040 4th 8/4/2065 GOAL Paying off living expenses for the next 6 months. Purchase Aaffordable car used or new. Purchase/build new pc. Finance a vacation at Japan after graduation. Save funds to purchase or rent a house near furture work. Build an emergency fund. Plan Your Debt Repayment for Student Loans. Build a duplex Start my own agecny business. Build my child's college fund Payoff my mortgage Save for retirement to alllow myself to live a standard lifestyle. ANTICIPATED COST used=$500 New-$650 $4,800 1,500 $3,000 $17,850 $2,500 $16,000 $60,000 $40,000 45,000 1,000,000 $329,680 Worksheet 5 - Simplified Income Statement Worksheet Your Take-Home Pay Total Income 50000 Total Income Taxes 10000 - 5000 Total Savings Expense Net Income = 35000 Your Living Expenses 10000 200 250 500 Total Housing Expenditures + Total Food Expenditures + Total Clothing and Personal Care Expenditures + Total Transportation Expenc + Total Recreation Expenditur + Total Medical Expenditures + Total Insurance Expenditure + Total Other Expenditures + Total Living Expenditures (add lines D through K) 15000 20000 150 = 46100 -11100 Income ND Expenses Car Payments Total PITI PITI Debt 4167 Credit Payments School Payments Mortgage / Rent Food Utilities 300 400 1500 795 200 120 3315 U17 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Clipboard A X fx B D E F Balance Sheet - Calculating Your Net Worth Assets Value Cash $500 + $5,000 Checking Savings/CDs + $12,000 Money Market Funds + Other Monetary Assets + Monetary A A. A. $17,500 Mutual Funds Stocks + CD + $5,000 Life Insurance (cash-va + Cash Value of Annuitie + Investment Real Estate + Other investments Investment + B. B. = $5,000 401(k) and 403(b) Company Pension Keogh + + IRA + Other Retirement Plans C. Retirement C. = $0 Primary Residence + 2nd Home Time-Shares/Condomi + + Other Housing Housing (m D. D. = $0 Automobile 1 Automobile 2 Other Automobiles E. Automobile E. = $0 Collectibles Boats Furniture Other Personal Propert + Personal Pr F. F. = $0 Money Owed You + Market Value of Your B Other G. Other Asse G. = $0 H. Total Asset H. = $22,500 +++ G H I J Number K L M N 0 P Balance Sheet - Calculating Your Net Worth (continued) Liabilities or Debts Value I. Current Bill I. = $12,000 Visa Master Card + Other Credit Cards J. Credit Card J. = $12,000 + First Mortgage 2nd Home Mortgage Home Equity Loan Other Housing Debt Housing K. + K. $0 Automobile 1 Automobile 2 + Other Automobile Loar Automobile L. L. = $0 College Loans $2,000 Loans on Life Insuranc Bank Loans + Installment Loans Other + M. Other Debt $2,000 N. Total Debt $14,000 Net Worth H. Total Asset $22,500 N. Less: Total $14,000 O. Equals: Net $8,500 M. N. H. N. 0. + = Q R Styles S T U V 4167 nts ents ments Rent W X Cens 300 400 1500 795 200 120 3315 Y Z B8 36%-(M PITI + M Debt Payment)/Gross M Income B D 1 2 Ratio Formula Calculation Comments Monetary Assets/ This number means I could pay off my credit 1.46 and still have money left over. 3 Current Current Liabilities 4 Monetary Assests/ Non Discretionary This number is strong since our goal for an 5 Emergency Expense 5.279034691 emergency fund should provide 5-8 months. 6 28%- M-Piti/M 7 HR1 Income 36%-(M PITI + M Debt Payment)/Gross M 8 HR2 Income 9 Total Savings Contributions/Total 10 Saving Ratior Income 10.00% 11 12 13 MORTAGE ----> Total Monthly Payment for your house 14 PITI- Principle, Interest, Taxes, and Insurance 15 16 17 A E DESIRED ACHIEVEMENT PRIORITY LEVEL DATE 1st 12/20/2022 2nd 3/4/2023 4th 5/4/2023 3rd 1/4/2023 Intermediate-Term Goals (1 to 10 years) 2nd 1/4/2027 1st 1/4/2026 3rd 1/4/2030 4th 6/14/2032 Long-Term Goals (greater than 10 years) 1st 2/4/2034 3rd 3/4/2038 2nd 6/4/2040 4th 8/4/2065 GOAL Paying off living expenses for the next 6 months. Purchase Aaffordable car used or new. Purchase/build new pc. Finance a vacation at Japan after graduation. Save funds to purchase or rent a house near furture work. Build an emergency fund. Plan Your Debt Repayment for Student Loans. Build a duplex Start my own agecny business. Build my child's college fund Payoff my mortgage Save for retirement to alllow myself to live a standard lifestyle. ANTICIPATED COST used=$500 New-$650 $4,800 1,500 $3,000 $17,850 $2,500 $16,000 $60,000 $40,000 45,000 1,000,000 $329,680