View the step-by-step solution to:

A five - year project has an initial fixed asset investment of $290 , 000 , an initial NWC 3 investment of $25 , 000 , and an annual OCF of - $35 ,

Please help me find the formula on Excel. What is the formula for each highlight cells?

38.png

38.png

A five - year project has an initial fixed asset investment of $290 , 000 , an initial NWC
3
investment of $25 , 000 , and an annual OCF of - $35 , 000 . The fixed asset is fully
depreciated over the life of the project and has no salvage value . If the required
return is 1 1 percent , what is this project's equivalent annual cost , or EAC ?
4
Initial fixed asset investment $
290, 000
Initial NWC investment
$
25, 000
\00 "
Annual OCF
( 35 , 000 )
Required return
17 %
10
* Depreciation staight - line
11
over life
5
12
13
14
Complete the following analysis . Do not hard code values in your calculations*
You must use the built-in Excel functions to answer this question .
15
16
Cash flows
17
Year O
18
Year !
A
D
E
F
G
H
I
J
Year 2
Year 3
Year 4
Year 5
UP UP
NPV
26
EAC

Top Answer

View the full answer
i1.png

AutoSave (. Off
6
L
Book1 - Excel
Sign in
X
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
?Tell me what you want to do
Share
do
Calibri
11
A A
=
ab Wrap Text
General
EAT O
Paste...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online