post the excel sheet

FINANCIAL CALCULATOR ALGORITHM Goal? Accumulate $1 million in Net Worth Inflation Rate: 2% Interest Rate for Loans: 4% Investment Interest Rate: 7% Depreciation Rate: 10% INCOME: Job Investments - INTEREST Short Term Savings Long Term Savings Retirement Inheritance/Win The Lottery/ EXPENSES: Taxes Social Security College Loans Rent/Housing/Insurance Furniture Phone I Gas/Electric Water/Sewer Cable Food Doctor/Medicine Clothes Entertainment Car Payment/Transportation (Payment, Interest, Depreciation) Gas, Tolls Insurance Repairs To figure out monthly costs from annual costs: Divide Sor interest by 12 What are the Algorithms? On a Monthly basis: Job Income + Short Term (ST) Investment Income + Long Term (LT) Investment Income - INCOME What Is Investment Income? ST Savings Balance = (Last Month's Balance + Job percentage + Last Month's Interest LT Savings Balance - (Last Month's Balance + Job. percentage + Last Month's interest Value of Investments + Value of Car + Value of House + Value of Furniture/Clothes/Etc. - ASSETS Value of Car = Prior Month's Value +/-a % Value of House - Prior Month's Value +/-a % Value of Furniture/Clothes/Etc. = Prior Months' value +/-a % Taxes + Purchases + Bills + Interest + Etc. - EXPENSES Taxes = Job* about 25% Social Security - Job - 7% College Loan = Payment per month (won't worry about interest) List Monthly Expenses Individually (Sub Total For Ease of Calculating) Income + Assets - Expenses = Net Worth Dl Focus FINANCIAL CALCULATOR ALGORITHM Goal? Accumulate $1 million in Net Worth Inflation Rate: 2% Interest Rate for Loans: 4% Investment Interest Rate: 7% Depreciation Rate: 10% INCOME: Job Investments - INTEREST Short Term Savings Long Term Savings Retirement Inheritance/Win The Lottery/ EXPENSES: Taxes Social Security College Loans Rent/Housing/Insurance Furniture Phone I Gas/Electric Water/Sewer Cable Food Doctor/Medicine Clothes Entertainment Car Payment/Transportation (Payment, Interest, Depreciation) Gas, Tolls Insurance Repairs To figure out monthly costs from annual costs: Divide Sor interest by 12 What are the Algorithms? On a Monthly basis: Job Income + Short Term (ST) Investment Income + Long Term (LT) Investment Income - INCOME What Is Investment Income? ST Savings Balance = (Last Month's Balance + Job percentage + Last Month's Interest LT Savings Balance - (Last Month's Balance + Job. percentage + Last Month's interest Value of Investments + Value of Car + Value of House + Value of Furniture/Clothes/Etc. - ASSETS Value of Car = Prior Month's Value +/-a % Value of House - Prior Month's Value +/-a % Value of Furniture/Clothes/Etc. = Prior Months' value +/-a % Taxes + Purchases + Bills + Interest + Etc. - EXPENSES Taxes = Job* about 25% Social Security - Job - 7% College Loan = Payment per month (won't worry about interest) List Monthly Expenses Individually (Sub Total For Ease of Calculating) Income + Assets - Expenses = Net Worth Dl Focus