What is the present value

Assignment Help Finance Basics
Reference no: EM133057111

A 24 year old employee makes $100,000 per year with her employer. At a 4% discount rate, what is the Present Value of her and her employer's future contributions (combined) to the Social Security program over the course of her career with her employer. (She will retire from her employer in 20 years.) Assume that her salary grows 2% each year, that tax rates remain constant, and that the wage base grows 3% per year. Remember, the current tax rate is 6.2% for the employee and 6.2% for the employer (of gross wages up to $142,800.)

Please show your spreadsheet.

Also, please explain/show any and all formulas typed into the Excel spreadsheet.

Reference no: EM133057111

Questions Cloud

Rate of return that shareholders expect to receive : You purchase 5,000 shares in XYZ Limited at a price of R80 ea. XYZ has just produced free cash flows of R0.80 per share.XYZ is expected to achieve a constant gr
Calculate pil share price today : Powell Industries Ltd (PIL), based in St. Andrew, has secured a new contract making them the sole supplier of commercial oxygen in Jamaica for the next three ye
How should Olive Ltd report this transaction : Required According to accounting standard, how should Olive Ltd report this transaction in its financial statements for the year ended 31 December 20X3
What is the net advantage to leasing : Carolina Trucking Company (CTC) is evaluating a potential lease for a truck with a 4-year life that costs $40,000 and falls into the MACRS 3-year class.
What is the present value : A 24 year old employee makes $100,000 per year with her employer. At a 4% discount rate, what is the Present Value of her and her employer's future contribution
What was accumulated value of the fund at the end of year : Derek deposited $14,000 into a fund at the beginning of every quarter for 13 years. What was accumulated value of the fund at the end of year
Law enforcement professionals and investigators : Law enforcement professionals and investigators use digital forensic methods to solve crimes every day.
Evaluation of formation and operational issues : Dave and Donna, a newly married couple, plan to quit their jobs, move to Wyoming, and open a software development business. Initially, they want the business to
What is the post-tax cost of debt : GG Company just paid $0.85 as a dividend, expected to grow at 5.0%. The most recent stock price is $82. What is the post-tax cost of debt

Reviews

Write a Review

Finance Basics Questions & Answers

  What will your monthly payments be

You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 6.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be?

  Gogreen has made the following projections

The price for each unit in the first year will be AU$50,000. This price will increase each year by 5%.

  What are the financial measurements used in an organization

Many organizations state that a focus on quality is a critical part of their mission. How does an organization specifically measure achieving quality related goals? What are the financial measurements used in an organization as part of their monit..

  Compute the expected returns of tamaya airlines

The following information is provided on the forecasted returns of two firms SIA Airlines Ltd and HQ Furniture Ltd.

  Organization initiative impact costs

Dell a leading computer technology organization has established a high ethical standard of doing business with customers, vendors, stakeholders, suppliers and shareholders.

  Why is preparing a financial plan so important

Why is preparing a financial plan so important? How do financial ratios fit into the preparation of a financial plan?

  Determine the expected return for securities

Using the expectations hypothesis theory for the term structure of interest rates, determine the expected return for securities with maturities of two, three, and four years based on the following information.

  Distinguish between savings and investing whats the

specifically address the following required elements1 distinguish between savings and investing whats the difference

  A firm has free cash flow to the firm

A firm has free cash flow to the firm equal to $150 million in year 1 and that cash flow is expected to grow at 2% forever. What is the value of share of stock, if WACC is 9.5%, cost of equity is 12%, the value of debt is $500 million and there are 1..

  How large must each of the two payments be

One year from today you must make a payment of $4,000. To prepare for this payment, you plan to make two equal quarterly deposits.

  What would be the value of the product line

Entrepreneurial Inc. is evaluating a new product launch that will cost it $36267 to launch. The company projects it will generate $622123 in annual operating.

  Chips home brew whiskey management forecasts that if the

chips home brew whiskey management forecasts that if the firm sells each bottle of snake-bite for 20 then the demand

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