Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is written in the I5 cell? Because i type =H5*(1+$1$2)^-C5 and it says that there is a problem with my formula help y as

What is written in the I5 cell? Because i type
=H5*(1+$1$2)^-C5
and it says that there is a problem with my formula
help image text in transcribed
y as below. C D E year O on 2 NH 3 8 4 5 Tax= 0.38 MARR 0.1 Taxable Income BTCF Depreciation Income Taxes ATCE PW - 180,000 H180000 180000.00 36,000 180000 -0.2 HDS-ES -FS SES2 305+65 H5"[1+$1$2)A-CS 36,000 1800000+ 0.32 -D6-E6 --F6 SES206+G6H6*(1+$1$2)A-C6 36,000 180000*0.1920 07-07 --F7"$E$2 -07+G7 -H7(1+$1$2)^_C7 36.000 1800000.1152 -08-E8 --F8 SES2 =08-G8 H8*(1+$1$2)A-C8 36,000 180000"0.1152 09-09 -F9 SE$2 09+G91H9"[1+$1$2) C9 36.000 180000"0.0576 =010.E10 =-F10 SES: -D10+G10 =H10"(1-$1$2)A-C10 36,000 0 2011-E11 --F11 SES: 011+G11 H111 S1$2) C11 36,000 0 2012-E12-F12 SES: 2012-G12 =H12"(1+$1$2jA_C12 36,000 0 =013-E13 --F13"SES =D13+G13 -H13+(1+$1$2]^.c13 36.000 0 014.E14 --F14 SES: 2014-G14 H141(1+$1$2)AC14 30,000 0 2015-E15-F15 SES: D15 G15 H1571-S1S2]-C15 NO 9 10 11 12 13 14 15 16 17 18 9 10 10 PW. SUM(14:115) (do not forget to write the = sign) ambers: right click the mouse in the cell you which to modify, select format cell and number

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alan J. Marcus, Alex Kane

6th Edition

0072861789, 9780072861785

More Books

Students also viewed these Finance questions