Please use excel and explain how you solved it step by step thank you How much income should an investment of 100,000 $ made today, in order to make a profit with 7% interest, bring in per year for 10 years?

Please use excel and explain how you solved it step by step thank you How much income should an investment of 100,000 $ made today, in order to make a profit with 7% interest, bring in per year for 10 years?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 11EB: How much would you invest today in order to receive $30,000 in each of the following (for further...

See similar textbooks

Related questions

Q: You have an investment account that started with $3,000 10 years ago and which now has grown to…

A: To maintain and increase the buying power of the money invested, an investment's rate of return…

Q: if you invest $10,000 per year at the end of each year for three years at in 6.7% rate of return…

A: Future Value Annuity = PMT×Where:FV - future value of the annuity.PMT - annual payment r - annual…

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: what is the amount of these 4 investment payments?

A: The annual payment will be made at the end of year 4 and year 5. The value of these payments at the…

Q: Consider two investments:1. Invest $1000 and receive $110 at the end of each month for the next 10…

A: Investment 1: Initial investment=$1000Interest rate=12% Uniform annual benefit=$110 Investment 2:…

Q: You currently have $8,700 to invest. You can invest the full amount now for a period of 9 years at…

A: Final Value after 9 years = $15,000Initial Value = $8,700Number of years (n) = 9

Q: What is the present value of an investment of $5,000 per year for 8 years with 10% interest

A: Given information : Amount per year = $5,000 Number of years = 8 Annual interest rate = 10%

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: If you invest $3000 today at 7% per year, how much will it be worth in 30 years? PLEASE SHOW WORK IN…

A: The objective of the question is to calculate the future value of an investment of $3000 at an…

Q: How many year and how many days

A: The formula for calculation of future value is as under FV = P (1+ RT) P= Principal R = Rate of…

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: 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: Now, drawing on your understanding of how to calculate present value of future investment,…

A: interest rate = 12% cumulative present value factor for 10 years = 5.650 future value of investment…

Q: You are going to invest $9237 today and $9695 1 year from today. If you expect to earn a return of…

A: Step 1 Future value is the amount of money that, with time and an interest rate, is invested now and…

Q: Suppose you make a one-time $ 8,000 investment into an account that yields a 12% annual return. If…

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

Q: You need $32,000 at the end of 10 years. If you can earn 0.625% per month, how much would you need…

A: Present value is the current value of future cash flows at a given discount rate. It is given as: PV…

Q: You started an investment account 10 years ago with $2100, and it now has grown to $8900. a. What…

A: Future Value refers to the value of the current asset or investment or of cash flows at a specified…

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: How much will be in an investment account 12 years from now if you deposit $3000 now and $5000 four…

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 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: What is the rate of return on an investment of $10,606 if the company will receive $2,000 each year…

A: The rate of return on an investment is the ratio of profits earned on an investment made by the…

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: Suppose that you can earn 15% compounded monthly. You would like to have $100,000 in 5 years. You…

A: Given, Rate is 15% compounded monthly Amount required is $100,000 term is 5 years

Q: You just deposited $9,500 in an investment account and will deposit $5000 more four years from now.…

A: Here,AmountDeposited today is $9,500Amount deposited four years from now is $5,000Interest Rate is…

Q: Starting next year you plan to deposit $1000 each year into an account earning 9.25% effective…

A: As per the given information: Deposits made each year - $1000 Effective annual return - 9.25%…

Q: You just deposited $6, 500 in an investment account and will deposit $ 5000 more four years from…

A: Investing is like planting seeds with the hope they will grow into something more valuable over…

Q: Problem #1. You invested $150 at the end of every month for 10 years at 7% interest compounded…

A: Monthly Investment (C) = $150 Monthly interest rate (r) = 0.00583333333333333 (i.e. 0.07 / 12)…

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 want to receive $5000 per month for 20 years in real dollars in an account when you retire in 35…

A: Payment after retirement = par = $5000 number of payment after retirement = nar = 20 * 12 = 240…

Concept explainers

Present Value

Present value (PV) is defined as the current or present value of all future sums of cash flow or money at a specified rate of return. This rate of return is known as the discounted rate, which is essentially the interest rate, discounted over some time. The expected cash flows are discounted at a discount rate to compute the present value. The higher the discount rate, the higher the future value (FV), but the lower the present value.

Question

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

Introduction

VIEW

Working and computation

VIEW

Conclusion

VIEW

Step by step

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

Please use excel and explain how you solved it step by step thank you How much income should an investment of 100,000 TL made today, in order to make a profit with 7% interest, bring in per year for 10 years?
Suppose you inherited $200,000 and invested it at 6% per year. How much could you withdraw at the beginning of each of the next 15 years? use excel format
Suppose you make a one-time $ 8,000 investment into an account that yields a 12% annual return. If you keep the account for 10 years, what should be the account balance? Round your answer to 2 decimal places
You have $76,000 in your account that you want to grow to triple that amount in 25 years. What annual rate of return is necessary to reach your goal? (Note: Enter your answer is a decimal, not a percentage. For example, enter .0452 instead of 4.52%) Your Answer: Answer
Starting next year you plan to deposit $1000 each year into an account earning 9.25% effective annual return. How many years will it take for your account to grow to $20,000, if you increase your deposit each year by 5%? (Hint: use excel goal seek).
Please use GoalSeek on Excel and show all the steps Suppose that you can earn 15% compounded monthly. You would like to have $100,000 in 5 years. You already have $10,000 saved. How much should you put away every month to have that amount in 5 years? Find this datum using GoalSeek.
If you invest $56,000 today in an account that pays 8.3% a year, how much will you have in 31 years?Formula?Excel Function?
You invested $2m today in an account that is expected to earn 15% annually for the next five years. As a result of this investment, the account will pay you the same amount $Y per year for the next five years, after which you will have $0 in the account. At the end of year 1, what is the balance in the account after the withdrawal of the first $Y?
What is the present value of $1,400 a year at a discount rate of 8 percent if the first payment is received 7 years from now and you receive a total of 25 annual payments? Could you please show how this can be solve by using Excel? Thank you.
Problem #1. You invested $150 at the end of every month for 10 years at 7% interest compounded monthly. Use formulas (not tables) to calculate (a) How much your investment is worth after 10 years. Show your work. (b) If you had invested the money at the beginning of each month rather than at the end, how much would be in your account? Show your work.
Calculate how much you would have in 15 years if you saved $7,000 a year at an annual rate of 8 percent with the company contributing $1,750 a year. Use (Exhibit 1-A, Exhibit 1-B. Exhibit 1-C. Exhibit 1-D). Note: Use appropriate factor(s) from the tables provided. Round time value factor to 3 decimal places and answer to 2 decimal places. Future value
Suppose an income stream will produce income at a rate of 4000 + 1000t dollars per year for 5 years, and is invested into an account that earns interest at an annual rate of 6% compounded continuously. (a) How much total income does the income stream produce? (b) How much money will be in the account after 5 years? (c) What is the present value of the income stream?