Compare the calculated present values

Assignment Help Finance Basics
Reference no: EM132049762

Question: Present value - Mixed streams Consider the mixed streams of cash flows shown in the following? table

Cash Flow Stream

Year A B
1 $22,500 $7,500
2 $18,750 $11,250
3 $15,000 $15,000
4 $11,250 $18,750
5 $7,500 $22,500
Totals $75,000 $75,000

(a) Find the present value of each stream using a 11?% discount rate

(b) Compare the calculated present values and discuss them in light of the undiscounted cash flows totaling ? $75,000 in each case.

(c) Show computations using an Excel Spreadsheet. When solving for the present value of a single cash flow using an Excel? spreadsheet, you will need to enter the values of? Rate, Nper,? Fv, Pmt, and Type into the present value function

Reference no: EM132049762

Questions Cloud

What if the appropriate discount rate is ten percent : (Present value of a growing? perpetuity) What is the present value of a perpetual stream of cash flows that pays $2,500 at the end of year one and the annual.
What is the molar solubility of m : The Ksp of some metal hydroxide, M(OH)3, is 2x10-31 at 25oC. What is the molar solubility of M(OH)3(s) in a solution that is buffered at pH 4.47 at 25oC?
What will be the ph of the new solution : If 22.0 mL of 0.182 M NaOH solution is added to 100. mL of solution which is 0.100 M in HA (Ka = 5.00x10-5) and 0.100 M in NaA, what will be the pH of the new
Find the minimum amount of wages that garro must receive : Under the Fair Labor Standards Act, the minimum amount of wages that Garro must receive for a 40-hour workweek is
Compare the calculated present values : Compare the calculated present values and discuss them in light of the undiscounted cash flows totaling ? $75,000 in each case.
What would the mole fraction of benzene be : What is the Molar Mass of the unknown? Calculate what the new boiling point would be. What would the mole fraction of Benzene be?
How many culumns wide would you expect the g-block to be : The current periodic table has only four blocks corresponding to different subshell types, but if the table were extended one more period
Why do the difference in the pvs occur : Present value for various discounting periods Find the present value of $500 due in the future under each of these conditions.
What amount of warranty expense will appear on the income : Other accrued liabilities-warranties - What amount of warranty expense will appear on the income statement for the year ended December 31, 2013

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the particular relevance of their domestic currency

Given that many multinationals based in many countries have much greater sales outside their domestic markets than within them, what is the particular relevance of their domestic currency?

  Project management course

How do you define quality on a project? Which tools and techniques do you think are a necessity for planning a project's quality management?

  Decision on present values

Which option will you choose if you base your decision on present values? Which option will you choose if you base your decision on future values?

  Fixed-rate bond underlying the swap

The six-month LIBOR rate at the last reset date (three months ago) was 7%. (i) What is the value of the fixed-rate bond underlying the swap?

  What is the net cash used in investing activities

Also, the firm had a net inflow of $300,000 from the sale of assets. What is the net cash used in investing activities?

  Student income based payment

The former student contacts the student loan servicer for an income based payment plan. The former student's income based payment equals $100 per month.

  How much will rachel have to pay sally per year

How much will Rachel have to pay Sally per year over the next five years to take over the lemonade stand?

  Importance of time value of money concepts

Describe and discuss the significance of the following time value of money concepts including compounding (future value), discounting (present value) and annuities.

  What must the average beta of the new stocks

After investing the additional funds, she wants the fund's required and expected return to be 13.00%. What must the average beta of the new stocks be to achieve the target required rate of return?

  Construct a classified balance sheet for 2015

From the following balance sheet accounts, construct a classified balance sheet for 2015 and 2014, list all working capital accounts (names, not amounts) and find the net working capital for the years ended 2015 and 2014

  Discuss the financial statement presentation

Discuss the financial statement presentation and disclosures associated with consolidations related to Off balance sheet transactions, Variable-Interest Entities, and Noncontrolling Interest.

  Estimate pharma sustainable sales growth rate based

Estimate Pharma's sustainable sales growth rate based on its 2010 financial statements. What financial policy change might Pharma Biotech make to improve its sustainable growth rate? Show your calculations. Estimate the additional funds needed (AFN) ..

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