I need help with a Excel formula. Gross margin in 2021E is 47,5%. So, the gross profit in 2021E is 49 200*0,475 = 23 370. After 2021E the gross margin decreases with 2,5 % per year. Example: 2022E will then be a 45 % gross margin, which will be 50,430*0,45 = 22,694
MY QUESTION IS:
What formula and anchoring can i use in G11, also, 2022E so i can just "CTRL + R" and get all the years correct, ?
# Lagre automatisk H - Jw_Practice_xam_Case Study_A 12 Suk ALTU thomasindal TL Kommentarer - Egendefinert D Autos TROT 7 Normal 222 AY Hyperlink 22 Darlig Normal Neytral Sul Betinget Tomate fummaling comel- Carter on Cake etter Slattformet God - " Ohjem wymru - F Tall Scler Celer Redigering H M N P 2 R 5 T LI HAM Sett inn Sidrappselt Former DATA Se gjennom visning jep - X Kipput Anal Narrow - 11-AA A = = 9 Bryttat in Kopier Lim FKU... 9.A. - - nn Kopier format Sammen og midtil Anpre Utopad Suit: F Juster ng G11 fx 02 AA C D F 1 Corporate Finance Insuler. All rights reserved 2 Historical and Forecast Financial Information 3 AGUSTUS 4 S 2018A 2019A 2020A 2021E Income Statement 9 Sa es Revenue $50000 $45000 $48000 $49 200 10 Cost of Sains $22500 $22500) $284003 11 Gross Profit $27500 $22 500 $21 800 12 13 SCAA Express (533761 (536001 14 Depreciation Expense (54250 (51 806) (54080 13 income Before Income Taxes $19 500 $15 300 $13 820 10 Income Taxes (55 363) (548951 (544881 17 Net Income $14138 $10 406 $9 412 18 2022E 2023E 2024E 2025E 2026E 2027E 2028E 2029E 2030E $50430 $51691 $52983 $54308 $56066 $57067 $54483 $58945 $61 444 19 20 22 Balance Sheet Asserts Cash Cash Egalents Accounts Recenable Total Current Assets 24 25 $36 388 55 000 $4139 $35491 54438 $39923 $34773 54734 $39 500 Property Plant & Ecumen. Total Assets $23 750 $55 138 $31825 $74 858 $45845 $ $85 353 sssssss ass Liabilities Accounts Payable Total OurrentLisbines 35 000 55000 $5 315 55315 36 378 56378 Long Term Debu Total Liabilities SO 55 000 SO 55 316 SO 56378 Cover Control Panel Financial Model DO WACC + + 100% L 0 A NCB de 2013 08.02.2002 # Lagre automatisk H - Jw_Practice_xam_Case Study_A 12 Suk ALTU thomasindal TL Kommentarer - Egendefinert D Autos TROT 7 Normal 222 AY Hyperlink 22 Darlig Normal Neytral Sul Betinget Tomate fummaling comel- Carter on Cake etter Slattformet God - " Ohjem wymru - F Tall Scler Celer Redigering H M N P 2 R 5 T LI HAM Sett inn Sidrappselt Former DATA Se gjennom visning jep - X Kipput Anal Narrow - 11-AA A = = 9 Bryttat in Kopier Lim FKU... 9.A. - - nn Kopier format Sammen og midtil Anpre Utopad Suit: F Juster ng G11 fx 02 AA C D F 1 Corporate Finance Insuler. All rights reserved 2 Historical and Forecast Financial Information 3 AGUSTUS 4 S 2018A 2019A 2020A 2021E Income Statement 9 Sa es Revenue $50000 $45000 $48000 $49 200 10 Cost of Sains $22500 $22500) $284003 11 Gross Profit $27500 $22 500 $21 800 12 13 SCAA Express (533761 (536001 14 Depreciation Expense (54250 (51 806) (54080 13 income Before Income Taxes $19 500 $15 300 $13 820 10 Income Taxes (55 363) (548951 (544881 17 Net Income $14138 $10 406 $9 412 18 2022E 2023E 2024E 2025E 2026E 2027E 2028E 2029E 2030E $50430 $51691 $52983 $54308 $56066 $57067 $54483 $58945 $61 444 19 20 22 Balance Sheet Asserts Cash Cash Egalents Accounts Recenable Total Current Assets 24 25 $36 388 55 000 $4139 $35491 54438 $39923 $34773 54734 $39 500 Property Plant & Ecumen. Total Assets $23 750 $55 138 $31825 $74 858 $45845 $ $85 353 sssssss ass Liabilities Accounts Payable Total OurrentLisbines 35 000 55000 $5 315 55315 36 378 56378 Long Term Debu Total Liabilities SO 55 000 SO 55 316 SO 56378 Cover Control Panel Financial Model DO WACC + + 100% L 0 A NCB de 2013 08.02.2002
