Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. this is a excel homework,how to do this in excel?

this is a excel homework,how to do this in excel? The following table shows two...

60.1K

Verified Solution

Question

Accounting

this is a excel homework,how to do this in excel?

The following table shows two schedules of prospective operating cash inflows, each of which requires the same net initial investment of $10,000 now. The required rate of return is 8% compounded annually. All cash flows occur at the end of each year. In terms of net present value, which plan is more desirable? Use cell references and the PV function to answer this question.

Ans. Annual Cash Flow

Year Plan A Plan B

1 $3,000 1000

2 $5,000 2000

3 2,000 3000

4 3000 4000

5 2000 5000

Total 15000 15000

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Sketch the region enclosed by the given curves. Decide whether to integrate with respect to x...

Basic Math
Q

Chapter 3, problem 21. An electrochemical battery is used to provide 1 milliwatt (mW) of power...

Chemistry
Q

To examine the work environment on attitude toward work, an industrial hygienist randomly assigns a group...

Statistics
Q

In the crowd funding case study what is ethical issues and recognition

Advance Math
Q

3. Consider the following linear program: MIN 6x1 + 9x2 ($ cost) s.t. x1 +2x2 ?8 10x1 + 7.5x2...

General Management
Q

Which of the following statements referring to the schema of a replication bubble is true...

Biology
Q

In 199m is In circle F G and J are points of tangency Determine whether...

Geometry
Q

Question 29 Recudd

Statistics
Q

A company has $40 per unit in variable costs and $1,200,000 per year in fixed...

Accounting
Q

a) b) Assume Novak Corporation restricted retained earnings in the...

Accounting
Q

Questionnaire is a tool used to Collect; a. Primary Data b. Secondary Data c. Time...

Finance
Q

a. What is the yield on a 1-year T-bill? Round your intermediate calculations and final...

Finance