Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help me with this accounting problem directions confuse me about excel. please show me the right way Required information A potential investment requires

can someone help me with this accounting problem directions confuse me about excel. please show me the right way
image text in transcribed
image text in transcribed
Required information A potential investment requires an initial cash outlay of $450,000 and has a useful life of 10 years. Annual cash receipts from the investment are expected to be $195,000. The salvage value of the investment is expected to be $55,000: The company's tax rate is 35%. The entire initial cash outlay (without any reduction for salvage value) will be depreciated over 10 years. Assume a discount rate of 17%. Show your Excel input and calculated net present value after-tax. (If a variable is not used in the calculation, input a zero (O). Omit the "S" and "%" signs in your response. Rolund answers to the nearest dollar and use a minus sign - ) for negative numbers.) Excel input 9 Rate Nper PMT PV FV $ Required: Show your Excel input and calculated internal rate of retum after-tax. (If a variable is not used in the calculation, input a zero (O). Omit the "$" and "%" signs in your response. Round answers to the nearest dollar / whole number and use a minus sign (-) for negative numbers.) Excel / calculator input: Rate % Nper PMT $ PV $ FV Internal Rate of Return (IRR)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Front Office Operations And Auditing Workbook

Authors: Patrick J. Moreo, Gail Sammons, Jeff Beck

2nd Edition

ISBN: 0130324930, 978-0130324931

More Books

Students also viewed these Accounting questions

Question

Distinguish between a current liability and a long-term debt.

Answered: 1 week ago

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago