An investment offers a total return of 13.8 percent over the coming year. You believe the total real return will be only 9.4 percent. What do you believe the exact inflation rate will be for the next year? Please show how to solve this by using Excel, thank you.

An investment offers a total return of 13.8 percent over the coming year. You believe the total real return will be only 9.4 percent. What do you believe the exact inflation rate will be for the next year? Please show how to solve this by using Excel, thank you.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: You are performing a sensitivity analysis on your project to see how inflation will affect its rate…

A: The internal rate of return method is one of the capital investment methods which determine the rate…

Q: Which of the following investments a return-maximizing investor would select? Select one: O a. An…

A: Please refer to the image below.

Q: For the average saver, the real rate of interest on his or her savings is %. (Round your response to…

A: As per company policy it is only possible to solve one question at a time. so solving the first one.…

Q: (b) Once upon a time, a bank was advertising an interest rate for savings account of i% per year. A…

A: Information Provided: Interest rate = 6% NOTE: As per our policy, we only answer one question…

Q: An analyst has the following projected free cash flows for an investment: Year 1: $125,050; Year 2:…

A: Present value of an investment refers to the current value of a future stream of cash flows or…

Q: You invest $94.1, and your investment account shows $107.9 at the end of year one, $97.9 at the end…

A: The formula for the Annual Holding Period Return (HPR) is given by:HPR Let's calculate the HPR for…

Q: Assume you deposit $1,000 in your savings account. Performance a sensitivity analysis on the…

A: Here,Deposit is $1,000Time Period is 10 years

Q: A financial services product is offered to you. It pays you $50,000 one year from today if the S&P…

A: Fair value is the value based on the required rate of return and most likely positive cash flow of…

Q: (Present value of complex cash flows) You have an opportunity to make an investment that will pay…

A: Cash Flow in Year 1 is $100Cash Flow in Year 2 is $300Cash Flow in Year 3 is $500Cash Flow in Year 4…

Q: Calculating the Number of Periods You've been offered an investment that will pay you 7 percent per…

A: We know, Future value = Present value x (1+r) ^ t where, r= periodic interest rate t = number of…

Q: A loan officer is preparing the documents for a commercial term loan. The borrower's risk profile…

A: APR is the annual percentage rate. EAR is the annual effective rate. APR is the nominal rate or the…

Q: A loan officer is preparing the documents for a commercial term loan. The borrower's risk profile…

A: APR is the annual percentage rate. EAR is the annual effective rate. APR is the nominal rate or the…

Q: An investor has to decide how much he will be willing to pay for an investment that generates the…

A: The present value of future cash flows will be helpful in finding out the total investment which is…

Q: You are evaluating an investment that promises a series of varying annual payouts over the next five…

A: Given information:Payouts over the next five years are $200, $200, $300, $400 and $600, respectively…

Q: Question : An annuity pays $100 at the end of each period for 10 periods. Set up the CFs in an Excel…

A: Present value of cash flows represents the total present worth of future cash flows calculated at a…

Q: If an investment advisor promises to double your money in 6 years, she is promising an annual rate…

A: Using the following formula we can compute annual rate of return.Future Value (FV) = Present Value…

Q: Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site.…

A: Horizon value also called the terminal value of an investment or security is the present value of…

Q: Say you own an asset that had a total return last year of 16 percent. Assume the inflation rate last…

A: Given information,Return: Inflation rate: To calculate,Real return

Q: Compute the Payback Period, Discounted Payback Period, Net Present Value, Internal Rate of Return,…

A: Capital projects are those that are spread across several years and requires a significant initial…

Q: You are considering a $7,000 investment. The table shows the possible outcomes in cash flow next…

A: Standard deviation refers to the dispersion of the data values from its mean value. The higher the…

Q: Suppose an investment offers to triple your money in 12 months (don't believe it). What rate of…

A: ParticularAmountFuture Value (FV)3Present Value (PV)1No. of Quarters (NPER)4

Q: Give typing answer with explanation and conclusion Q87. You are considering two investments.…

A: APR stands for annual percentage rate and it is the stated rate or the nominal rate which is 10% for…

Q: An investment is expected to generate cash flows of $20,000 next year (at time t=1), and $10,000 in…

A: Given: Year Particulars Amount 1 Cash inflows $20,000 2 Cash inflows $10,000 Growth rate…

Q: Please help me in calculating the Return on Investment and Break-Even Point, and please help me…

A: The amount of net income earned on the basis of capital employed is known as the return on…

Q: 6b. An initial $2000 investment is made that returns profits of $1000 and 1500 in the first and…

A: Here, Initial Investment is $2,000 Profit in Year 1 is $1,000 Profit in Year 2 is $1,500 Inflation…

Q: 12. Nominal versus Real Returns Say you own an asset that had a total return last year of 12.1…

A: Nominal rate = 12.1% Inflation rate = 3.4% Real rate of return = [(1 + Nominal rate)/(1 +…

Q: Array Solutions requires a 14.0% return on their projects. Analysis shows that even though they have…

A: The returns are classified as earned and real return where earned or nominal return represent the…

Q: . If we make a payment of $1,725 each month starting today into a fund that earns 6%, how many…

A: Monthly payment = $1,725Interest rate = 6%Future value = $100,000

Q: uestion 1: Solve the following TVM problems using Excel formulas. You MUST use Excel formulas (FV or…

A: a. Future value$ 81,102.53b. Future value$ 85,289.85c. Future value$ 444,644.11Explanation:The above…

Q: A project will double your investment in one year with probability 0.58, otherwise you'll lose half…

A: Standard deviation of stock is computed as follows:-Standard deviation of stock = whereR= returnER=…

Q: Ten annual returns are listed in the following table 19.9% 16.6% - 50.0% a. What is the arithmetic…

A: Arithmetic average return = Total Return / Number of yearsResult:-Arithmetic average return = 8.05%

Q: Construct a spreadsheet to convert a nominal interest rate compounded m times per year i(m) and…

A: The nominal rate when compounded per period gives the effective rate of interest. The effective rate…

Q: Consider the following analysis of two alternatives, X & Y: YR X Y 0 -200 -1000 1 30 250 2 30 250 3…

A: Given The first cost of alternative X =200 Annual revenue from X =30 Salvage value =70 For…

Q: (i will give thumbs up please solve within 15 minutes)

A: Value at Risk: This is a technique that helps in determining losses in a company or firm over a…

Q: Your consulting firm will produce cash flows of $190,000 this year, and you expect cash flows…

A: a. The present value of growing annuityCF1 = 190,000 * 1.012 = 192,280PV = $846,974.47 b. With no…

Q: Assuming a 1-year, money market account investment at 4.97 percent (APY), a 2.96% inflation rate, a…

A: Answer 1: Information Provided: APY = 4.97% Inflation rate = 2.96% Marginal tax = 28% Balance =…

Q: (Expected rate of return and risk) B. J. Gautney Enterprises is evaluating a security. One-year…

A: As per Bartleby honor code, the expert is required only to solve that part, which is explicitly…

Q: You have invested $10,000 in this ETF at the beginning of year 2020 and its year-end value was…

A: Rate of return refers to the return earned on an investment or asset over a fixed period of time.…

Q: Sales Depreciation EBIT Tax Rate, T Net Working Capital Net Property and Equipment Long-Term Debt…

A: Value of company can be calculated as the present value of free cash flow based on the WACC of the…

Q: Compute the profitability index for the following proposal, assuming the desired minimum rate of…

A: The objective of the question is to calculate the profitability index for a project proposal. The…

Q: ) The initial outlay of the investment is €125,000. The income stream is €30,000 in vear 1, €55,000…

A: Net present value(NPV) is the difference between present value of all cash inflows and initial…

Q: ket has an expected return of 9% per year with a standard deviation of 25%. You have designed a…

A: Probaility is very important in stock where uncertainty is very high probability show chance of…

Q: You are researching interest rates and their forecasts. Your research provides you with the…

A: Profit is the amount earned in return of an investment.

Q: An analyst has the following projected free cash flows for an investment: Year 1: $125,050; Year 2:…

A: Introduction:We will find the IRR of the cash flow to determine the discount rate used in…

Q: Suppose that a 10-year T-note is purchased with a face value of $20,000 and a coupon rate of 3.4%…

A: Return means an additional amount earned over the invested amount. It is computed on the basis of…

Q: The ERR is %. (Round to two decimal places.) A maximum of IRR value(s) is(are) suggested by the…

A: Multiple IRR is a scenario where an Investment gives an NPV of Zero for more than one Required Rate…

Q: (Related to Checkpoint 7.1) (Expected rate of return and risk) B. J. Gautney Enterprises is…

A: Expected return is calculated as follows:-Expected return = whereR= Return of stockP= Probability of…

Question

Please show how to solve this by using Excel, thank you.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Find the present worth sum of money that would be equivalent to the future amounts of $5000 in year 6 and $7000 in year 8 if the real interest rate is 10% per year and the inflation rate is 5% per year. Solve using the factors and their equations with (a) an inflation-adjusted rate, and (b) the real interest rate. Solve manually please
An investment will provide the following future cash flows. Year 1 = 5,919 Year 2 = 8,327 Year 3 and 4 = 4,718 Year 5 = 3,048 Using a 9.01% discount rate, what is the present value of this investment?
A firm expects to make payments of 1.1, 1.5, 1.2, 1.4 and 1.9 million for a particular supply over each of the next 5 years. What constant annual payment is this equivalent to if the annual rate is 10%? That is, what is the time-value weighted average of this mixed-cash flow stream?
Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 14.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).
B. J. Gautney Enterprises is evaluating a security. One - year Treasury bills are currently paying 3.0 percent. Calculate the investment's expected return and itsstandard deviation. Should Gautney invest in this security?Probability,ReturnProbability,Return0.20,-6%0.40, 1%0.20, 7%0.20, 8%
a. What is the NPV of investing today? The NPV is $428,235.29. (Round to the nearest dollar.) b. What is the NPV of waiting and investing tomorrow? The NPV if the rate goes up is $0. (Round to the nearest dollar.) The NPV if the rate goes down is $ 563,404.25. (Round to the nearest dollar.) The PV is $444,242. (Round to the nearest dollar.) c. Verify that the hurdle rate rule of thumb gives the correct time to invest in this case. The hurdle rule is $249,887.64. (Round to the nearest dollar.) (Select from the drop-down menu.) The NPV <0, so wait
After a 1 year investment you receive 7.4% interest (nominal) from your bank. However, looking at how prices have changed, you soon realize that the real rate of interest was actually 3.4%. How much was inflation during that year? Enter your answer as a percentage, rounded to 2 decimals, and without the percentage sign ('%'). For example, if your answer is 0.02345, then enter 2.35
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window: Assuming a discount rate of 16 percent, find the present value of each investment. a. What is the present value of investment A at 16 percent annual, discount rate? S (Round to the nearest cènt.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) INVESTMENT B END OF YEAR 1 23456TBLG 7 8 9 10 A $18,000 18,000 18,000 18,000 18,000 $18,000 18,000 18,000 18,000 18,000 18,000 C $18,000 90,000 18,000 -
Suppose the term structure of risk-free interest rates is as shown here: a. Calculate the present value of an investment that pays $1,000 in 2 years and $4,000 in 5 years for certain. b. Calculate the present value of receiving $900 per year, with certainty, at the end of the next 5 years. To find the rates for the missing years in the table, linearly interpolate between the years for which you do know the rates. (For example, the rate in year 4 would be the average rate in year 3 and year 5.) c. Calculate the present value of receiving $2,700 per year, with certainty, for the next 20 years. Infer rates for the missing years using linear interpolation. (Hint: Use a spreadsheet.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) 2 years 3 years 5 years 7 years 1 year 2.06 2.44 2.64 3.22 3.74 Term Rate (EAR, %) Print Done 10 years 4.25 20 years 5.09 I X t cent.)
You are required to find how long it will take a sum of money (or anything else) to grow to some specified amount with a certain compound interest rate. Specifically, if a company’s investment has a real rate of return of 4% per year and the inflation rate is 6% per year, approximately how long will it take for the investment to triple?
An investment will provide the following future cash flows. Year 1 6,768 Year 2 = 3,989 Year 3 and 4 = 6,869 Year 5 = 1,797 Using a 9.96% discount rate, what is the present value of this investment?
State the return rate (in %) for your optimal portfolio.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS