ZuoTi.Pro
Question

Eulis Co has identified an investment project with the following cash flows. If the discount rate...

Eulis Co has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows? What is the present value at 18 percent? at 24 percent? Can someone show me how to build an excel spreadsheet to answer this question?

sorry..

year 1 cash flow $680

year 2 cash flow $490

year 3 cash flow $975

year 4 cash flow $1160

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text Copy B 1 프 . 灬 ▲· 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard HC251 GV Alignment Number Edting GW GX GY GZ НА HD HG 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 (4 , 커 | | RATION Pfp ARR. EULIS YEAR CFAT PV FACTOR @ 10% PV OF C FAT 0.9091 0.8264 0.7513 0.6830 618.18 404.96 732.53 792.30 2547.97 NOTE ON PV FACTOR 1/(1+r)^n 1/(1+0.10)A1 1/(1+0.10)A2 1/(1+0.10)A3 1/(1+0.10)A4 490 975 1160 4 PRESENT VALUE YEAR CFAT PV FACTOR @ 18% PV OF CFAT 0.8475 0.7182 0.6086 0.5158 576.27 351.91 593.42 598.32 2119.91 NOTE ON PV FACTOR 1/(1+r)An 1/(1+0.18)^1 1/(1+0.18)A2 AND SO ON 490 975 1160 4 PRESENT VALUE extemal rate MIRR NpV IRR REPLACEMENT S . . . HPR GMAM EAC MACRS RATIOCASHBUDGET /w acc BOND EPS EBIT, REPLACEMENT . STats , NPV -Iii! , erences: JF17 27-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut aCopy E AutoSum ー E ゴWrap Text ▲· 逻锂函Merge & Center. $, % , 弼,8 Paste B 1 프 . 灬 Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard HC269 GV Alignment Number Cells Edting GW GX GY GZ НА HB HC HD HE HF HG 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 (4 , 커 | | RATION Pfp ARR. YEAR CFAT PV FACTOR @ 24% PV OF CFAT 680 490 975 1160 0.8065 0.6504 0.5245 0.4230 548.39 318.68 511.38 490.65 1869.09 4 PRESENT VALUE extemal rate MIRR NpV IRR REPLACEMENT S . . . HPR GMAM EAC MACRS RATIOCASHBUDGET /w acc BOND EPS EBIT, REPLACEMENT . STats , NPV -Iii! , rences: JF17 27-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
Eulis Co has identified an investment project with the following cash flows. If the discount rate...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT