I could use some guidance in filling out this excel doc. The financial results for quarter 5 are on the second-fourth photo. I need the financial information for my case write-up.

Case 4--Merger Analysis INPUT DATA: Tax Rate 20.00% Assumed Growth in TA 2.00% Assumed Growth in TR 5.00% Assumed Long Run Growth in TR 3.00% Assumed TL/TA (CGS -D + SGA)TR Depreciation/TA Assumed Cost of Debt Discount Rate 32.00% Shares Outstanding ,650,000 Current price per share $8.90 TERMINAL VALUE ANALYSIS: Multiple Valuation Weight Product Pure DCF N/A 1.00 $0 05 Annual T+ 1 T + 2 T + 3 T +4 Total Assets $24,641,580 #N/A $25.134.412 Total Liabilities $1,759,881 #N/A Total Equity $22,881,700 #N/A Change in TE #N/A #N/A TL/TA 7.14% #N/A TL/TE 7.69% #N/A 05 Annual T+ 1 T + 2 T + 3 T + 4 Total Revenue $10,114,625 $40,458,500 $10,620,356 $42,481,425 $11,151,374 $44,605,496 Less:CGS - D + SGA ($2,911,603) ($11,646,412) ($2, 788,395) Gross Margin $7,203,022 $28,812,088 $7,203,022 Less: D ($6,160,395) ($24,641,580) ($6,160,395) EBIT $1,042,627 $4,170,508 $1,042,627 Less: I ($156,394) ($625,576) ($156,394) EBT $886,233 $3,544,932 $886,233 Less: T ($177,247) ($708,986) ($177,247) NI $708,986 $2,835,945 $708,986 Plus: D $6,160,395 $24,641,580 $6,160,395 Equals: cash Flow $6,869,381 $27,477,525 $6,869,381 Less: Change in TE Equals: Avail. CF Expected Terminal Value SO Free Cash Flow Maximum total offer, total: Maximum offer price per share:Account Settings Logout Supplemental Materials View Other Groups FinGameONLINE5.0 Set View Permissions Help View Students Edit Simulation Environment Edit Economic Index Set Student Controlled Set When Quarters Can Be Use Sample Decisions Run Student Edit Pro Forma Decision Inputs Run Pro Forma Simulation View Pro Forma Results Edit Actual Decision Inputs Run Actual Simulation View Actual Results Decision Inputs for Quarter Number 5 Company Operating Decisions Units to be produced 100, 080 Per unit price $104.50 Div. per common share $0.25 Advertising cost $0 Demand/price forecast $75, 080 Sales discount 2.00% Investment Decisions Short-term investment $1, 800, 080 Risk of S-T investment Machine units bought Units of plant bought Project A no Project B no Financing Decisions Short-term loans $0 Preferred shares Two-year loans Common shares Three-year loans Common tender price Ten-year bonds se Special Options Strike settlement (per hr. ) $0.00 Dollar penalty $0 Quarterly Performance Report Quarter Number 5 Sales revenue ( 98, 605 units at $104.50 ) $10, 114, 625 Income from securities 24,486 $10, 139, 111 Cost of Goods Sold: Beginning Inventory: ( 2,374 at $80.16 ) $190, 291 Materials $2,800, 080 Direct Labor 3,383,546 Total Direct Costs $5, 383, 546 Warehousing Costs $7, 307 Depreciation: Mach. and Equip. 654, 692 Plant 1,326, 500 Other Overhead Costs 215,271 Total Indirect Costs 2,203,769 Production Costs ( 100,080 at $75.87 ) 7,587,317 Goods Available for Sale ( $75.97 per unit ) $7, 777, 607 Less: Ending Inventory ( 3, 769 units ) 286,340 Cost of Goods Sold 7,491, 267 Gross Profit $2, 647, 843 Selling and administrative expenses $1, 580, 731 heducation.com/fg/fg.html 1/311/25/2019 fg Quarterly EPS $0.38 Dividend Yield 8.73% Price earnings ratio 5.85 Marketable Security Yield 1.113% Actual unit price $102.82 Actual unit demand 104, 226 Preferred stock price $21.37 Preferred dividend yield 4. 68% Return on investment 10.19% Return on equity 10.97% call premium: preferred 8.08% Bond call premium 8.00% Common tender or sell/sh $0.00 Unpaid preferred dividend/share 00 . 0$ Outstanding debt yields: Short-term 2-year Loan 3-year Loan Bonds Penalty Loan 1. 669% 3.110% 2.500% 1.400% 8.000% INFORMATION FOR FUTURE QUARTERS: Units forecast 105, 168 106, 344 119,322 86, 178 Price per unit forecast $103.91 $104.26 $106.64 $101.15 Second forecast: units 109, 039 106, 980 114, 808 104, 669 Second forecast: price $102.58 $102.64 $103.30 $101.50 Third forecast: units 108,952 112,162 121, 034 108, 466 Third forecast: price $103.24 $104.60 $105.99 $103.57 Units of plant capacity 100,000 100, 080 75,080 75, 008 Units of machine capacity 100, 000 45, 080 45, 080 40, 008 Other overhead 215,271 215,271 215,271 215, 271 Depreciation: Machinery $51, 250 262,508 262,500 240, 080 Projects 103,442 103, 442 103, 442 103, 442 Plant 1, 502, 060 1, 502, 080 1, 148, 250 1, 148, 250 Principal repayment on debt: Short-term 2-year 3-year Bonds 300, 000 300, 080 300,000 300, 080 Warehouse fees: Units First 2000 Next 5000 Over 7000 Cost/Unit $1.80 $3.00 $8.00 Production costs per unit next quarter: Materials $20.15 Machinery $51.00 Plant $347.00 Units First 60,000 Next 40,000 Next 20, 080 Over 120, 000 Labor cost $38.27 $27.93 $23.79 $34.14 Rates on funding in quarter 6 Short-term 2-year loan 3-year loan Bond Preferred 1. 627% 2. 092% 2. 558% 3.057% 3.943% Interest due next quarter: Short-term $0 Intermediate Bonds $16, 800 Capital budgeting projects for next quarter: Life Cost Unit Capacity Overhead Saving Unit Labor sav., Qtr.6 Change/Qtr. Labor Sav. A 2-yr $498, 360 100, 080 $11, 442 $0. 62 $0.80 B 3-yr $511, 752 120, 000 -$9,374 $0.85 -$0.03