Question: 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:

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

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!

1. Given the facts of the case, what communications do you believe Forrester & Loomis should have made with the audit committee with regard to the transactions with the vendor to comply with PCAOB AS...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

Executive Memorandum (EM) Guidelines Prepare an executive summary of the papers that is only one page long.The assignment should be typed in Word, font size 11 double spaced, with minimum margins of...

hello, can you please help me answer the questions attached. Attached is the case merger and sample write-up. Its be in Times New Roman 12-point font, double-spaced and 4 pages. Any supporting...

FIN3130 Coursework 2015-16 Introduction Robinson Investments is a private equity fund specialising in the acquisition of underperforming publicly quoted companies. Its strategy is to buy-out the...

Answers to cybertext project. Fill in the blanks. Lengthy project. General ledger, unadjusted trail balance, statement of cash flows. adjusted trial balance, income statement. Need to finish by 11:00...

Please help out Cash Budget & Pro-forma Statements Case Case: Utensil Box Inc. Due Date: Friday December 11,2020 - This assignment is worth (10 %)of your course grade. Required: 1 Produce projected...

I need short journal entries for these articles, please. 1) Learning Objectives By the end of this section, you will be able to: Explain the various functions of money Contrast commodity money and...

Evaluate the potential gains and losses for forwards,future,call options,put options and swaps. Outline and describe the different risks that each type of derivative contract faces. Describe...

CF identity to check out Us Q2. Using the following financial statements for Pamplin Inc.: (8 Points) BALANCE SHEET FOR YEAR 2012 and 2013 (*000 S) ASSETS Cash $ 200 Account Receivable 450 Inventory...

1. The question to be addressed is, what would be the impact of the project in terms of short-term profitability? Quantify the impact by projecting the income statement for the next year and...

Some 213.9 million pounds of fireworks were used in the United States in 2009, and that amount decreased by about 20.1 million pounds per year until 2013 (Source: American Pyrotechnics Association)....

A shell-and-tube heat exchanger (1 shell pass, 2 tube passes) is to be used to condense 2.73 kg/s of saturated steam at 340 K. Condensation occurs on the outside tube surfaces, and the corresponding...

Find the indefinite integral: e 3 x c o s ( x ) d x

State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each...

Refer to E8-39B. Tech Systems needs 80,000 optical switches next year (assume same relevant range). By outsourcing them, Tech Systems can use its idle facilities to manufacture another product that...

Franklin, Inc. uses activity-based costing to account for its chrome bumper manufacturing process. Company managers have identified four manufacturing activities: materials handling, machine setup,...

Bixel Components manufactures products A1 and A2 from a joint process. Total joint costs are $250,000. The sales value at split-off was $292,500 for 2,700 units of product A1 and $157,500 for 900...

In 2011, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2013. Information related to the contract is...

After a merger presentation from the CEO extoling the benefits of the merger, Tom is excited about working with a team of developers in the company in which his is integrating and talks about his...

If newcomers actively seek out information, what impact should this have on the socialization process and socialization outcomes? Make at least one recommendation for how an organization can use this...

Identify and describe three potential problems common to orientation programs. How can each of these problems be overcome?

Why is the issue of statistical power important to HRD evaluation (see Appendix)? Describe two ways a researcher can increase power while controlling the cost of evaluation.