Question: This is an excel sheet: What data is needed extracted to be applied to the other sheet: EXCEL DATA: Period Ending 1 2 / 3

This is an excel sheet: What data is needed extracted to be applied to the other sheet: EXCEL DATA: Period Ending 12/31/202012/31/202112/31/2022 Assumptions Inputs 20232024202520262027 Sensitivity Analysis
Total Revenue 31,536,000,00053,823,000,00081,462,000,000 IGR 24.80%101,627,575,062126,785,053,314158,170,159,369197,324,516,264246,171,369,329 Receivables
Cost of Revenue 24,906,000,00040,217,000,00060,609,000,00074%74%75,204,405,54693,820,939,452117,045,917,933146,020,142,035182,166,813,303
Gross Profit 6,630,000,00013,606,000,00020,853,000,00026,423,169,51632,964,113,86241,124,241,43651,304,374,22964,004,556,025
Operating Expenses 4,636,000,0007,110,000,0007,021,000,000
Research Development 1,491,000,0002,593,000,0003,075,000,0004%4%3,836,203,3014,785,839,2745,970,553,6337,448,539,0439,292,393,517
Selling General and Administrative 3,145,000,0004,517,000,0003,946,000,0005%5%4,922,815,6836,141,437,9767,661,725,0859,558,352,86611,924,482,868
Non Recurring --00%0%-----
Others -122,000,000162,000,000-219,000,0000%0%-----
Earnings Before Interest And Taxes 1,902,000,0006,714,000,00013,910,000,00017,664,150,53222,036,836,61227,491,962,71834,297,482,32042,787,679,641
Interest Expense 748,000,000371,000,000191,000,000 IntR ofDebt 3.50%531,290,565809,943,0981,157,574,8921,591,261,4732,132,305,340
Income Before Tax 1,154,000,0006,343,000,00013,719,000,00017,132,859,96621,226,893,51426,334,387,82632,706,220,84740,655,374,301
Income Tax Expense -1,142,0001,033,0005,732,00021%21%3,597,900,5934,457,647,6385,530,221,4436,868,306,3788,537,628,603
Minority Interest -172,000,000-125,000,000-4,000,0000.00%-0.20%-203,255,150-253,570,107-316,340,319-394,649,033-492,342,739
Non-recurring Events 0.00%0%-----
Discontinued Operations 0%0%-----
Extraordinary Items --00.00%0%-----
Effect Of Accounting Changes --00.00%0%-----
Other Items -00.00%0%-----
Net Income 690,000,0005,519,000,00012,583,000,00013,331,704,22316,515,675,76

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!