Answered: Suppose you save $2,800 a year for 43…

Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how much will you have at the end of the periods? Formula $ ??? Excel Functon $1,066,616.08

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 17EA: Gardner Denver Company is considering the purchase of a new piece of factory equipment that will...

See similar textbooks

Related questions

Q: A contract requires end-of-month payments of $240 for another 9 1/4 years. What would an investor…

A: > The amount willing to pay for the investment shall be computed by applying the present value…

Q: A firm has issued $25 million in long-term bonds that now have 8 years remaining until maturity. The…

A: Capital structure is one of the useful concept being used in business. This shows out of total…

Q: Harold Reese must choose between two bonds: Bond X pays $92 annual interest and has a market value…

A: Yield-to-Maturity(YTM) shows the average annual return earned if investment is not sold and retained…

Q: An investment will pay $50 at the end of each of the next 3 years, $250 at the end of Year 4, $300…

A: CF1 = $50 CF2 = $50 CF3 = $50 CF4 = $250 CF5 = $300 CF6 = $550 Interest rate, r = 10%

Q: Q#2: Debt to Assets Ratio Debt to Equity…

A: "Since there are multiple questions posted, answering only the first question as per the guidelines.…

Q: Can you please provide the formula for how to solve this. Can you show the actual calculation so I…

A: Risk free rate - It is the rate of return wherein the Beta is zero.Percentage allocated to the…

Q: From the following information calculate the net present value of the two projects and suggest which…

A: First, we need to determine the net cash flow using the formula below:Net cash flow = cash flow +…

Q: The Neal Company wants to estimate next year's return on equity (ROE) under different financial…

A: Return on equity refers to the return to be earned by the equity shareholders in a definite period…

Q: Determine the ERR (External rate of return) of the cash flows if external rate Cash Flow Year 0 1 2…

A: ERR is calculated as shown below.

Q: Give typing answer with explanation and conclusion What regular interest payment will grandmamma…

A: The time value of money (TVM) is a financial concept that recognizes the potential difference in…

Q: Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns…

A: Future value refers to the value of the current asset at some future date affected by interest and…

Q: ou were asked to estimate the cost of common based on the three most commonly used methods and then…

A: We can determine the cost of equity in 3 ways.1. Bond yield + Risk PremiumCost of equity = Bond…

Q: You bought a eight-year corporate bond two years ago at $950 per bond immediately after the annual…

A: Given:Face value of the bond: $1,000Purchase price of the bond: $950Annual coupon rate: 6%Time to…

Q: Give only typing answer with explanation and conclusion Tim’s corp has 10 million shares of common…

A: Weighted Average cost of capital is determined by adding weighted cost of capital from different…

Q: You and your friend, Edward, have been shopping for your new car for several weeks. Together, you’ve…

A: Adjusted cost refers to the cost bear by buyer or seller of the finance, in form of expenses or…

Q: Growth Enterprises believes its latest project, which will cost $86,000 to install, will generate a…

A: With next year cash flow (C), constant growth rate (g) and discount rate (r), the present value of…

Q: Consider a loan of $7100 at 4.8% compounded semiannually, with 18 semiannual payments. Find the…

A: Amortization schedule refers to the statement showing the details of the amount of borrowed amount,…

Q: You expect TAS stock to have a 12% return next year and a 30% volatility. You have $5,000 to invest…

A: To determine which stock to short in order to minimize investment risk, we need to consider the…

Q: The time between the acquisition of inventory and the collection of cash from receivables is called…

A: > Cash cycle was the period between purchase of inventory and collection of cash from accounts…

Q: Yr 1 2 the variance, standard deviations, and coefficient of variation for X and Y. Which stock is…

A: YearsRxRy112.209.6520.00-2.0036.5012.5048.009.57Required:Average Return=:Standard…

Q: Ruby-Star Incorporated is considering two different vendors for one of its top-selling products…

A: Average inventory value refers to the addition of the beginning and the closing inventory and its…

Q: Four years ago, Dorothy Stills bought six-year, 5.3 percent coupon bonds issued by the Sandhill…

A: Given data:> Face value = 1000> Periods = 4> Coupon amount = 1000*5.2% = 52> Price =…

Q: The following questions are based on a stock and its derivatives. Relevant information is listed in…

A: Working Note #1Computation of WACC:WACC=[Cost of debt * Wt. of debt * (1-Tax rate)]+ [Cost of equity…

Q: A firm has sales of $41,000, costs of $19,500, addition to retained earnings $5,100, dividends paid…

A: Here,Sales is $41,000Cost is $19,500Addition to Retained Earning is $5,100Dividend paid is…

Q: You are appointed to value a biotech company's ordinary shares. You forecast the following growth…

A: When the company receives profits and distributes them among the shareholders. That share of profit…

Q: If you have a 5.75% back-load charge and you invest $4,000, how much of this money will be invested…

A: There are two main types of fees or charges applicable in case of mutual funds.They are back load…

Q: A factory costs $980,000. You reckon that it will produce an inflow after operating costs of…

A: Net present value is the modern method of capital budgeting that is used to determine the present…

Q: Waldron Inc. issued $400,000 bonds with a stated rate of 7% when the market rate was 5%. They are…

A: Bonds are commonly used by investors to generate income and diversify their investment portfolios.…

Q: If a $100 par value preferred stock pays an annual dividend of $5 and comparable yields are 10…

A: Preference stock are the hybrid kind of security which have qualities of both equity and debt.…

Q: (Saving for retirement-future value of an annuity) Selma and Patty Bouvier are twins and both work…

A: The FV of an investment refers to the collective value of its cash flows assuming that they grow at…

Q: The Fourth Corp. is evaluating extra cash dividends versus share repurchases. In either case, $6,675…

A: Some time when company have extra cash than company pay dividends or may repurchase own shares from…

Q: Suppose you conduct currency carry trade by borrowing $1,000,000 at the start of each year and…

A: Borrowing = $1,000,000Exchange rate on January 1,2000 = NZ$1.9104/$

Q: Jordan, Corp., has debt outstanding with a market value of $3 million. The value of the firm would…

A: Given data:> Market value of the debt = $3 Million> Market value of the equity = 3,60,000 *…

Q: A company is projected to generate revenues of $336 million and $406 million over the next two…

A: Share value refers to the price used by the investors for trading the shares in the market for the…

Q: Guerilla Radio Broadcasting has a project available with the following cash flows : Year Cash Flow 0…

A: Payback period is the period required to recover initial investment but do not consider cash flow…

Q: Use the following data to complete the QUIZ: YEAR 0 1 2 3 4 WACC = 12.0000% Expected Net Cash Flow…

A: As per the Honor code of Bartleby we are bound to give the answer of first three sub part only,…

Q: The following table shows your stock positions at the beginning of the year, the dividends that each…

A: CompanySharesBeginning of year PriceDividend Per ShareEnd of Year PriceUS…

Q: Enterprises has bonds on the market making annual payments, with 15 years to maturity, a par value…

A: > Using excel PMT function> Where> NPER = Year's to maturity> PV = Price of bond> FV…

Q: a. A single-stock futures contract on a non-dividend-paying stock with current price $260 has a…

A: Future price is basically the stock price and the risk-free return generated on it.Formula for…

Q: A 15-year maturity bond with par value $1,000 makes semiannual coupon payments at a coupon rate of…

A: A bond is a kind of debt security issued by the government and private companies for raising funds…

Q: Total risk is measured by _____ and systematic risk is measured by _____. Group of answer choices…

A: Risk and return are fundamental concepts that are closely intertwined. They represent the trade-off…

Q: Determine the ERR (External rate of return) of the cash flows if external rate (e) is given as %14.…

A: Here,Required Return is 14%Cash Flows are as follows:

Q: Consider a no-load mutual fund with $200 million in assets and 11 million shares at the start of the…

A: Total assets at the start of year=$200 millionTotal assets at the end of year=$410 millionNumber of…

Q: Happy Time Inc. is expected to generate the following cash flows for the next year, as shown in the…

A: The expected return is the estimation of profit or loss that an investor determine from his…

Q: ABC corporation has $600 mil worth bonds outstanding at face value with a 8.5% coupon rate paid…

A: When the company receives profits and distributes them among the shareholders. That share of profit…

Q: Company ABC has asset turnover of 180% . Its equity multiplier and profit margin are 165% and 6%,…

A: Asset Turnover=180%Equity multiplier=165%Profit Margin=6%Dividend payout ratio=40%Required:ABC’s…

Q: Market Data Return Standard Deviation Beta Market Data 0.120 0.200 1.000 Risk-Free Rate…

A: As per the given information:To determine:Sharpe ratio, Treynor's measure, and information ratio.

Q: Could you please solve this question, without graphs or tables? Ensure the workout is correct and…

A: Project AlphaInitial Investment = i = $10,000Cash Flow in year 2 = cf2 = $12,000Time = t = 2…

Q: Novak Inc. now has the following two projects available: Project 1 2 Initial CF -11,659.64 -3,369.54…

A: The NPV of a project refers to the profitability of the project by discounting cash flows to find if…

Q: .Discuss how you would expect the financing choices of the following firms to differ and explain the…

A: The financing choices of a sole trading firm and a conglomerate are likely to differ due to several…

Question

I need the manual excel formula as well as the FV Excel Function.

C. Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how much will you have at the end of the periods?

Formula		$ ???
Excel Functon		$1,066,616.08

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Calculations

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.
Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
How much must be invested now to receive $30,000 for 10 years if the first $30.000 is received one year from now and the rate is 8%?
Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?
A grocery store is considering the purchase of a new refrigeration unit with an Initial Investment of $412,000, and the store expects a return of $100,000 in year one, $72000 in years two and three, $65,000 in years four and five, and $38,000 in year six and beyond, what is the payback period?
If you invest $15,000 today, how much will you have in (for further instructions on future value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
A restaurant is considering the purchase of new tables and chairs for their dining room with an initial investment cost of $515,000, and the restaurant expects an annual net cash flow of $103,000 per year. What is the payback period?
Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The discount factor for year 1 is 0.89 and for year 2 is 0.80. The NPV is a. 0 b. 6,800 c. 1,400 d. (4,000)