how do I put it in C20 do I do it as =C20*$B$7 I DID THIS AND I GET ######, CAN YOU PLEASE TELL ME HOW I WOULD PUT THIS INFO IN C20, ALSO I NEED STEP BY STEP EXPLANATION PLUS ANSWER THANKS

Merge & Centet - $ - % 9 % 9.88 Insert Delete Format Clipboard Font Conditional Format as Cell Formatting Table Styles Styles O Alignment 5 Number D22 X & fx Cells B C C E F G H U K L M N P A A A 1 Blue Marlin Car Wash 2 3 Assumptions 4 Cost of Building 5 Lifetime of Investment 6 Salvage Value 7 Tax Rate 8 9 10 Income Statement 11 Annual income from Car Wash Return on Investment Discount Rate NPV of investment IRR $350,000 15 S50,000 379 Is the proposed car wash profitable in terms of NPV & IRR? Why? 0 1 2 3 4 SO $70,000 $72,857 $75,714 $75,714 578,571 5 6 $81,429 584 285 Year 7 8 9 87.143 $90,000 $92,857 10 11 12 13 14 15 95,714 598,571 5101,429 5104,286 5107,143 $110,000 S350,000 SO $350,000 SO S25,000 $25,000 SO SO S26,786 528,571 $26,786 $28,571 SO $30,357 $30,357 SO 532, 143 S32,143 SO SO $33,929 $35,714 533,929 535.714 SO $37 500 $37,500 SO S39,286 $39,286 SO 541,071 S41,071 SO 542 857 $42,857 So So so $44,643 S46,429 $48,214 $44,543 $46,429 $48,216 SO S50,000 $50,000 13 Expenses 14 Building af Car Wash 15 Operatine Expenses 16 Total T 18 Initial Earnings 19 Depreciation of Equipment 20 Taxable income 21 22 Taxes Due 23 24 Net Income 25 SE50,000 $45,000 SO 56,908 S350.000) $38,092 546,071 56,908 $39,163 $47,143 548,214 549,286 $6,908 S6.908 56,90 $40,235 $41,306 $42,378 $50,357 551,429 552,500 S53,571 $54,543 555 714 S6,908 56,908 55,908 56,908 $6,908 55,908 543,449 $44,521 $45.592 $46,663 S47.735 $48.806 $56,786 557,857 56,908 56,908 549,878 $50,949 558,929 56.900 S52,021 S60,000 56,908 $53,092 SO 25 Documentation Year Investment Analysis Enter Type here to search 0 P W ? A 17 GO