Please do not give solution in image formate thanku. 2. Find the present worth of the cash flows shown. Some are expressed as constant-value (CV) dollars, and others are inflated dollars. Assume a real interest rate of10% per year and an inflation rate of 4% per year.YearCash Flow, $I Stated as3000CV26000Inflated348000 4000InflatedCV55000CV

Given data :year12345cash flow.$30006000800040005000stated as CVinflatedinflatedCVCV

Answered: 2. Find the present worth of the cash…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Find the accumulated value 28 years after the first payment is made of an annuity on which there are 5 payments of $200 each made at four year intervals. The nominal interest rate convertible semiannually is 6% Round your answer to two decimal places. 5130 14
If you are expecting to get OMR 11240 at the end of 9 years; calculate its present value if the interest rate is 24.2% and is computed quarterly? Select one: O a. 1909.19 O b. 9046.11 O c. 1356.38 O d. 9064.11
Find the total number of compounding periods and the interest rate per period for the investment. Term ofInvestment Nominal(Annual) Rate (%) InterestCompounded CompoundingPeriods Rate perPeriod (%) 6 years 4 quarterly %
Find the accumulated amount A if the principal P is invested at the interest rate of r/year for t years. (Use a 365-day year. Round your answer to the nearest cent.) P = $2000, r = 8%, t = 10 1/2, compounded semiannually A = $
What is the APR on a $700,000 fixed rate mortgage loan fully amortizing over 30 years if the stated annual interest rate is 5.5% and the lender charges 1.5% as an origination fee, $750 for an appraisal and $18 for a credit report? a.5.65% b.5.72% c.5.36% d. 5.5%
Find the accumulated amount A if the principal P is invested at the interest rate of r/year for t years. (Use a 365-day year. Round your answer to the nearest cent.) P = $180,000, r = 3%, t = 2 1/4, compounded monthly A = $
Please answer along with the excel formulas - 1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53 $1,870.61 $1,964.14 $2,062.34 $2,165.46 3. Last year Rocco Corporation's sales were $225 million. If sales grow at 6% per year, how large (in millions) will they be 5 years later? $271.74 $286.05 $301.10 $316.16 $331.96
Tara wishes to accumulate $25,000 in 5 years. Use the appropriate formula to find the sinking fund payment (in $) she would need to make at the end of each six months, at 4% interest compounded semiannually. (Round your answer to the nearest cent.)
If you have the following information Discounted Cash Flow Year Cash Flow Discounted Cash Flow 0 $ - 22 million 1 $2 million 2 $2 million 3 $8 million 4 $8million 5 $12 million The discount rate is % 5 Calculate the NPV
Evaluate the following statements:S1. Any investment income of general borrowing is deducted from capitalizable borrowing cost.S2. If the asset is financed by specific borrowing but a portion is used for working capital purposes, the borrowing shall be treated as general borrowing in determining capitalizable borrowing cost. a.False, False b.False, True c.True, True d.True, False
Which of the following statements describes the payment amounts over the life of an ARM? A) Payments will remain constant for the life of the loan. B) Payments may go up or down in relation to the index rate. C) Payments may go up or down in relation to the margin rate. D) Payments may go up or down in relation to the equity in the property.
One of your customers is delinquent on hisaccounts payable balance. You’ve mutually agreed to a repayment schedule of $700per month. You will charge 1.3 percent per month interest on the overdue balance. Ifthe current balance is $21,500, how long will it take for the account to be paid off ?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS