chapter 10 c 4 please only place data in the yellow cells 506862

Aug 29, 2021 | Uncategorized

Chapter 10, C 4. Please ONLY place data in the yellow cells.
1. Managerial Analysis
San Angelo Federal Bank
Capital Investment Analysis
Net Present Value Method
Net Present
Cash 12% Value
Year Inflows Factor* (Rounded)
1 $ — — $ —
2 — — —
3 — — —
4 — — —
5 — — —
5 (residual value) — — —
Total present value of cash inflows $ —
Total present value of cash inflows $ —
Net capital investment
Initial investment $ —
Less proceeds from sale of existing teller
machines —
Net capital investment —
Net present value $ —
* Table 1 in Appendix B on present value tables.
2. Mangerial Analysis
P 10-04 Name:
Section:
Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available.
An asterisk (*) will appear next to an incorrect entry in the outlined cells.
Leave no cell blank. Ensure to enter “0” wherever applicable. Round PV factors to three decimal places.
1.
a. Net present value method
Year Net Cash Inflows 12% Factor = Present Value
=
=
=
=
=
Total present value
Less purchase price of machine
Net present value
b.
Accounting Rate of Return =
=
=
c.
Payback period method
Total cash investment
Less cash flow recovery:
Year
Unrecovered investment
Payback period is years
2.
Net present value
Accounting rate of return
Payback period years