Chapter_09 - Chapter 9 Input boxes in tan Output boxes in...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 9 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may req the "Analysis ToolPak" or "Solver Add-In" be installed in Ex To install these, click on the Office button  then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and  "Solver Add-In," then click "OK."
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
quire that  xcel.
Background image of page 2
Chapter 9 Question 3 Input area: Year Cash Flow (A) Cash Flow (B) 0 1 2 3 4 Required payback Output area: Project A Payback 0.000 Project A Reject Project B Payback 0.000 Project B Reject
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 9 Question 6 Input area: Installation cost # of years Projected net income: Year 0 Year 1 Year 2 Year 3 . Output area: Average net income #DIV/0! Average book value #DIV/0! AAR #DIV/0!
Background image of page 4
Question 7 Input area: Required Return Annual cash flows: Year 0 Year 1 Year 2 Year 3 . Output area:
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

Chapter_09 - Chapter 9 Input boxes in tan Output boxes in...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online