Your team will develop an individual lsquolife financial

Assignment Help Finance Basics
Reference no: EM13348225

Your team will develop an individual ‘life' financial plan using the excel spreadsheet template provided in the Project D2L folder. Note: you are doing this work as a team, however, the spreadsheet is for an individual. You only hand in 1 spreadsheet for your group. (I would recommend that each of you create your own spreadsheet with your respective data for you to use in the future). You are to fill in (and add rows and columns as needed) the information for both your personal income statement and your personal balance sheet. You will need to add the respective formulas in the spreadsheet, so that the income statement and balance sheet are accurate and "tie" together. For example, your school loans (if you have them or expect them) would go into your liabilities and then you'd have lines in recurring expenses on your income statement as you pay off the loan. Input your expected salaries, costs, deductions, investments, etc. and summarize your assumptions in a clear manner so the logic can be easily understood. You will decide what your expected salary increases will be, when you will buy a house, what the house will cost, how much money you will plan to save in your retirement account vs. your regular savings account and when you will make major purchases. Research median salary data for your expected career and median home prices and/or rent prices in the area you plan to live. You will need to provide an amortization table for any loans that you incur (such as home mortgage and or car payments. You could do this in a separate worksheet in your spreadsheet).

You will also need to determine your income tax rate for each year. This can be found using the current US federal income tax brackets. You will need to research how these work and apply the correct formula in your spreadsheet. For simplicity, state income tax can be ignored.

You are expected to enter the appropriate formulas into the spreadsheet (linking your income statement and balance sheet appropriately) so that you will have a picture of your budget, your growing net worth, and your retirement portfolio. Also, some line items are missing on the spreadsheet and you will need to add them to make your spreadsheet complete and accurate.

Develop a plan that will generate an adequate amount of money to retire at age 55 (if you are currently in your early twenties. If you are older, then you may provide an appropriate retirement age). Complete the analysis out to age 95 to ensure that you will have adequate resources to provide for your entire life. Research what average rate of return can reasonably be expected in your 401k and other investments. Interest is compounded monthly. Assume that you receive NO social security benefits in later years (therefore, your investments have to provide all your required income in your retirement years). Again....clearly show your assumptions and explain your logic in the spreadsheet

 

 

Reference no: EM13348225

Questions Cloud

Question 1a develop a safety program to help reduce the : question 1a develop a safety program to help reduce the risks of electrical hazards in a workshopb in terms of
Qestion 1a worker is using a hand-held circular saw to : question 1a worker is using a hand-held circular saw to cut extruded aluminium strips in the manufacture of storm
Question 1a describe the main practical recommendations of : question 1a describe the main practical recommendations of the occupational safety and health management systems which
Question 1a joiner has received an electric shock from a : question 1a joiner has received an electric shock from a portable electric 230 v drill while fitting decorative ceiling
Your team will develop an individual lsquolife financial : your team will develop an individual lsquolife financial plan using the excel spreadsheet template provided in the
Provide all calculations necessary to support your : provide all calculations necessary to support your answerson january 8. 2010 the first day of your new company you
Question 1the charter for zippy inc authorizes the company : question 1the charter for zippy inc. authorizes the company to issue 500000 shares of 7 no-par preferred stock and
Question 1a define and explain the term groupb elaborate on : question 1a define and explain the term groupb elaborate on the importance of group normsquestion 2conflict is a
Question 1psychology is the science that studies behaviour : question 1psychology is the science that studies behaviour and mental processesa how can the knowledge of psychology be

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd