Question: 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
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
Get step-by-step solutions from verified subject matter experts
