Suppose you own a business and you expect to generate a profit of $50,000 next year. Each year after that you expect your profit to grow by 4%. If you earn profits for 10 years total and the discount rate is 8%, what is your company’s valuation today (present value)? (Show layout in Excel Please)

Suppose you own a business and you expect to generate a profit of $50,000 next year. Each year after that you expect your profit to grow by 4%. If you earn profits for 10 years total and the discount rate is 8%, what is your company’s valuation today (present value)? (Show layout in Excel Please)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 9EA: If you invest $12,000 today, how much will you have in (for further Instructions on future value in...

See similar textbooks

Related questions

Q: u are able to invest $100 at the end of 1 year into an investment earning 6%. At the end of year 2,…

A: Future value of money increases with due to accumulation of interest over the period of time of…

Q: If $10,000 is invested in a certain business at the start of the year, the investor will receive…

A: Computation of present value:Hence, the present value is $1,151.30.

Q: Future Value is calculated in Excel using the following function and pa Future Value = -FV(APR/12,…

A: Future Value refers to an investment's worth to be received in the upcoming time at a constant…

Q: An investment pays you $100 at the end of each of the next 3 years. The investment will then pay you…

A: Here,

Q: You are thinking on purchasing some assets that will give you 5,000€ per year, starting in 5 years,…

A: In order to decide whether to purchase the asset we need to find out the present value of cash…

Q: assume that at the beginning of the year, you purchase an investment for $7,200 that pays $100…

A: Initial value=$7200Final value=$6800Annual income=$100

Q: You own a company. This company’s projected revenue is $30,000 for year 1, $31,000 for year 2, and…

A: Present Value is the sum of all cashflows discounted at certain discount rate

Q: Calculate the annual benefits of a company, If the arithmetic gradient is 500$ for 6 years and the…

A: Annual benefit is the total gain within an accounting year.

Q: Suppose you have an investment offer that guarantees an average investment gain of $1,000 per year.…

A: The average rate of change describes the rate at which one quantity changes in relation to another.…

Q: Suppose that you plan to invest $1500 at the end of each of the next 9 years, and you want to have…

A: Rate of return refers to the minimum return to be earned by the investors on the initial investment…

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: Calculate how much you would have in 15 years if you saved $7,000 a year at an annual rate of 8…

A: Future value refers to the estimated value of an investment or asset at a future point in time,…

Q: Suppose the rates of return were 100% in the 1st year, -50% in the 2nd year. If you had invested…

A: Usage of IRR is helpful in determining the attractiveness of an investment opportunity to an…

Q: A math tee shirt business is expected to generate $19,000 in revenue per year for the next 10 years.…

A: Future value is the amount that a sum of money grows into future. The growth comes due to…

Q: For example, if you a simple average of 5 year of either income or cash flow of: year 1 100 year2…

A: There are various methods of valuing business. One such method is discounted cash flow method or Npv…

Q: uppose you save $4,000 per year at the end of each year for 30 years and earn 5% interest per year.…

A: Annual saving = $ 4000 Period= 30 Years Annual interest rate = 5% As per formula Value…

Q: Please use excel and explain how you solved it step by step thank you How much income should an…

A: The equivalent annual return is the periodic payment made towards the acquisition of an asset or…

Q: An example of how to calculate net present value is done using the following. Imagine you have been…

A: A method of capital budgeting that helps to evaluate the present worth of cash flow and a series of…

Q: Suppose you save $2,800 ayear for 43 years into an investment account that earns 8.5% return, how…

A: Yearly savings = $2800Period = 43 yearsInterest rate = 8.5%

Q: If you invest $56,000 today in an account that pays 8.3% a year, how much will you have in 31 years?…

A: Present Value, PV = $56,000 Interest rate, r = 8.3% Number of periods, n = 31 yearsThe future value…

Q: Suppose you are offered an investment opportunity that will pay $2,500 in five years if you invest…

A: We need to use equation below to calculate the annual rate of return of investment.WhereFVn = future…

Q: Suppose an income stream will produce income at a rate of 4000 + 1000t dollars per year for 5 years,…

A: Present value Present value of an amount with continuous compounding. With continuous compounding…

Q: Suppose you save $4,000 per year at the beginning of each year for 3 years and earn 5% interest per…

A: The formula for the calculation of future value of annuity due is as follows: Future value of…

Q: You have $76,000 in your account that you want to grow to triple that amount in 25 years. What…

A: Answer: Following information are given: Present value = $76,000 Time = 25 years Future value = 3…

Q: music studio predicts its future yearly net income (loss) to be as follows: Year 1: - $120 Year 2:…

A: NPV FORMULA: NPV=∑i=1nfuture cashflow1+ri where, n= number of years r=discount rate

Q: Assume that at the beginning of the year, you purchase an investment for $6,500 that pays $95 annual…

A: Initial Value at time 0 is $6,500Annual Income $95Value of Investment increased to $7050 in one year

Q: Your start-up company's net profit next year will be $50,000, and you then expect that to increase…

A: Equivalent annual worth provides a basis of measurement and comparison by converting the cash flows…

Q: Assume that at the beginning of the year, you purchase an investment for $6,300 that pays $130…

A: Rate of return on the investment has 2 components:(i) Annual income in the form of dividend,…

Q: What is the rate of return on an investment that costs $5,000, earned a $600 dividend during the…

A: The rate of return (RoR) indicates the percentage increase or decrease in the value of an investment…

Q: Suppose you inherited $200,000 and invested it at 6% per year. How much could you withdraw at the…

A: Withdrawal used to involve in the removing of the funds from the investment plans, savings plan,…

Q: You own a company. This company’s projected revenue is $30,000 for year 1, $31,000 for year 2, and…

A: PRESENT VALUE Present Value is the current value of a future amount of money or a series of Cash…

Q: Suppose you inherited $100,000 and invested it at 7% per year. What is the most you could withdraw…

A: 1) Present value of annuity is the sum of all future cashflows made at the end of every period…

Q: Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how…

A: The FV of an investment refers to the total value of its cash flows at a future date assuming that…

Question

(Show layout in Excel Please)

Video Video

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: Introduction

VIEW

Step 2: Computation of the company's valuation

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 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

An example of how to calculate net present value is done using the following. Imagine you have been given an investment opportunity wherein if you invest $1,200 today, you will receive $650 dollars at the end of each year for the next 5 years. You could separately choose to invest your money at 10% interest each year. Should you take the investment opportunity? To find the answer, use the NPV formula:
Suppose you save $2,800 ayear for 43 years into an investment account that earns 8.5% return, how much will you have at the end of the periods? Formula? Excel Function?
Assume that at the beginning of the year, you purchase an investment for $6,300 that pays $130 annual income. Also assume the investment's value has increased to $6,900 by the end of the year. a. What is the rate of return for this investment? Note: Input the amount as a positive value. Enter your answer as a percent rounded to 2 decimal places. Rate of return % b. Is the rate of return a positive or a negative number? Positive Negative
Please use Excel to solve: You have just purchased a share of stock for $20. The company is expected to pay a dividend of $0.50 per share in exactly one year. If you want to earn a 10% return on your investment, what price do you need if you expect to sell the share immediately after it pays the dividend?
Suppose that you plan to invest $1500 at the end of each of the next 9 years, and you want to have accumulated $19,500 at the end of this period, what rate of return would you need to achieve? 10% 9% 8% 11% 12%
Assume that at the beginning of the year, you purchase an investment for $7,200 that pays $100 annual income. Also assume the investment's value has decreased to $6,800 by the end of the year. (a) What is the rate of return for this investment? (Input the amount as a positive value. Enter your answer as a percent rounded to 2 decimal places.) Rate of return % (b) Is the rate of return a positive or negative number? Positive O Negative
Ten annual returns are listed in the following table (Click on the following icon in order to copy its contents into a spreadsheet.) 19.9% 18.0% 1.2% - 16.5% 45.6% 16.6% a. What is the arithmetic average return over the 10-year period? b. What is the geometric average return over the 10-year period? c. If you invested $100 at the beginning, how much would you have at the end? 50.0% 43.3% a. What is the arithmetic average return over the 10-year period? The arithmetic average return over the 10-year period is% (Round to two decimal places.) 45.2% -3.0%
Suppose you are offered an investment opportunity that will pay $2,500 in five years if you invest $2,000 today. What is the implied rate of return? A) 4.56% B) 4.00% C) 5.00% D) 3.62% E)25.00%
You expect a company to pay a dividend of 2.50 next year and 3.50 a share for the following 2 years. At that point, you expect that the dividend will increase by 4% every year. If your required return is 8%, what would you pay for the stock today? USE EXCEL
You just purchased a share of SPCC for $95. You expect to receive a dividend of $7 in one year. If you expect the price after the dividend is paid to be $115, what total return will you have earned over the year? What was your dividend yield? Your capital gain rate? The total return you will have earned over the year is _____%. (Round to two decimal places.) Your dividend yield will be ____%. (Round to two decimal places.) Your capital gain rate will be _____%. (Round to two decimal places.)
1. You just sold a stock for $85. If the stock appreciated at 6% annually, and you owned it for eight years, what was the original price that you paid for the stock? 2. You are considering buying some order fulfillment software that is projected to save your company $27,500 per year for 3 years. If the current rate your company uses to evaluate its investments is 9%, what are you willing to pay for this investment?
Suppose you have an investment offer that guarantees an average investment gain of $1,000 per year. (a) What is the average rate of change (in dollars per year) of this investment? $? per year (b) If the value of the investment today is $10,000, what will be the value (in dollars) of the investment in 2 years? $?