Please assist, I am trying to figure out the rest of this solution and fact check my data I have already added. Also projected budget both Var and Ratio data. All data I could find for the question was included.

If you look at HW help attachment, I attempted to figure out the first column from the attached data tables from the company fillings. I need help for the rest of the work sheet to solve the rest of the data.

For this Interactive Assignment, you are going to look at the financial statements for the company you selected and, using the previous quarter's financial data, interpret the data and propose a budget for the next Quarter based on your current and previous analysis of company performance.

• List your current sales, discounts and allowances, net sales, margins, operating costs, and earning before and after taxes.
• Choose a minimum of two financial ratios (below) and include in your analysis.
• Prepare the next quarter's budget based on your interpretation of past data.

Include at least two of the following types of relevant financial ratios in your analysis

Netflix: Operating Budget Q1 Var +/- Var % Budget Projection Next Q Revenue Sales Revenue Net income Investment Income Other Income [Prior Quarter] $6,644,442 $542,156| TOTAL INCOME [Prior Quarter] Budget Projection Next Q Var +/- Var % Costs and Expenses Advertising Technology and development General and Admin Interest expense Operating income Interest and other income (expenses) Income before taxes Benefit from income taxes $762,565 $486,936 $275,539 $197.186 $954,242 $250,639 $861,460 $35,739 TOTAL EXPENSES NET PROFIT/LOSS Net Earnings Before Taxes (Gain or Loss) Income Tax Expense Net Earnings After Taxes [Prior ] Prei. Q. Change Ratio Analysis (Choose a minimum of two) Profitability Ratio Liquidity Ratio Solvency Ratio Valuation Ratio Leverage Ratio in thousands, except per share data) ths Ended September 30, 2019 December 31, 2019 Twelve Months Ended December 31, 2019 March 31, 2020 Three Months Ended June 30, September 30, December 31, 2020 2020 2020 Twelve Months Ended December 31, 2020 $ 5,244,905 $ 3,097,919 553,797 379,776 233.174 980,239 5,467,434 $ 3,466,023 878,937 409,376 254,586 458,512 20,156,447 $ 12,440,213 2,652,462 1,545,149 914,369 2,604,254 5,767,691 $ 3,599,701 503,830 453,817 252,087 958,256 6,148,286 $ 3,643,707 434,370 435,045 277,236 1,357,928 6,435,637 $ 3,867,751 527,597 453,802 271,624 1,314,863 6,644,442 $ 4,165,160 762,565 486.936 275,539 954,242 24,996,056 15,276,319 2,228,362 1,829,600 1,076,486 4,585,289 Revenues Cost of revenues Marketing Technology and development General and administrative Operating income Other income (expense): Interest expense Interest and other income (expense) Income before income taxes Benefit from (provision for) income taxes Net income Earnings per share: Basic Diluted Weighted average common shares outstanding: Basic Diluted (160,660) 192,744 1,012,323 (347,079) 665,244 $ (177,801) (131,378) 149,333 437,637 586,970's (626,023) 84,000 2,062,231 (195,315) 1,866,916 $ (184,083) 21,697 795,870 (86,803) 709,067 $ (189,151) (133,175) 1,035,602 (315,406) 720,196 $ (197,079) (256,324) 861,460 (71,484) 789,976 $ (197,186) (250,639) 506,417 35,739 542,156 $ (767,499) (618,441)|| 3,199,349 (437,954) 2,761,395 $ $ $ 1.52 $ 1.47 $ 1.34 $ 1.30 $ 4.26 $ 4.13 S 1.61 $ 1.57 $ 1.63 $ 1.59 $ 1.79 $ 1.74 $ 1.23 $ 1.19 $ 6.26 6.08 438,090 451,552 438,547 451,367 437,799 451,765 439,352 452,494 440,569 453,945 441,526 455,088 442,220 455,283 440,922 454,208 G H | K L M N O Q R March 31, June 30, 2018 September 30, 2018 December 31, 2018 March 31, 2019 June 30, 2019 September 30, 2019 December 31, 2019 March 31, 2020 June 30, 2020 September 30, 2020 December 31, 2020 2018 $ 3,348,557 $ 5,004,247 $ 4,435,018 $ 5,018,437 $ 5,151,884 $ 7,153,248 $ 8,392,391 $ 8,205,550 2,593,666 $ 4,626,522 597,388 7,817,576 11,300,469 341,932 692,820 20,152,797 $ 3,906,357 $ 4,803,663 636,869 9,346,889 12,279,519 349,646 687,483 22,663,537 $ 3,067,534 $ 4,987,916 674,531 8,729,981 13,397,672 371.152 867,424 23,366,229 $ 3,794,483 $ 5,151,186 748,466 9,694,135 14,951,141 418,281 910,843 25,974,400 $ 820,350 4,168,907 20,878,317 434,372 1,737,036 27,218,632 $ 872,910 5,877,157 21,937,845 452,399 1,903,938 30,171,339 $ 892,740 5,327,758 23,227,772 481,992 1,904,189 30,941,711 $ 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 $ 1,295,897 6,447,781 25,266,889 650,455 2,694,785 35,059,910 $ 1,410,891 8,564,139 25,155,117 751,941 2,704,084 37,175,281 $ 1,434,089 9,826,480 25,067,633 828,118 2,900,312 38,622,543 $ 1,556,030 9,761,580 25,383,950 960,183 3,174,646 39,280,359 $ ABCDE 1 Netflix, Inc. 2 Consolidated Balance Sheets 3 lunaudited) 4 lin thousands) 5 6 7 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Current content assets, net 12 Other current assets 13 Total current assets 14 Non-current content assets, net 15 Property and equipment, net 16 other non-current assets 17 Total assets 18 Liabilities and Stockholders' Equity 19 Current liabilities: 20 Current content liabilities 21 Accounts payable 22 Accrued expenses and other liabilities 23 Deferred revenue 24 Short-term debt 25 Total current liabilities 26 Non-current content liabilities 27 Long-term debt 28 Other non-current liabilities 29 Total liabilities 30 Stockholders' equity: 31 Common stock 32 Accumulated other comprehensive income (loss) 33 Retained earnings 34 Total stockholders' equity 35 Total liabilities and stockholders' equity 36 $ 4,459,391 $ 436,183 436,121 673,892 4,537,578 $ 448,219 396,104 697,740 4,609,055 $ 441,427 531,035 716,723 4,681,562 $ 562,985 481,874 760,899 4,858,899 $ 439,496 750,720 808,692 4,846,525 $ 442,194 752,488 892,777 4,857,520 $ 444,129 1,040,745 915,506 4,413,561 $ 674,347 843,043 924,745 4,761,585 S 545,488 1,061,090 986,753 498,809 7,853,725 3,206,051 14,170,692 1,420,148 26,650,616 4,664,733 $ 446,668 986,595 1,029,261 499,161 7,626,418 3,208,164 15,294,998 1,710,948 27,840,528 4,429,536 656,183 1,102,196 1,117,992 499,878 7,805,785 2,618,084 15,809,095 1,982,155 28,215,119 6,005,587 3,444,476 6,542,373 139,631 16,132,067 6,079,641 3,604,158 8,342,067 141,071 18,166,937 6,298,240 3,593,823 8,336,586 127,927 18,356,576 4,599,654 $ 541,298 1,259,124 1,040,202 499,517 7,939,795 2,926,574 15,547,616 1,875,235 28,289,220 6,487,320 3,759,026 10,360,058 129,231 20,735,635 6,857,807 3,560,364 10,305,023 792,380 21,515,574 6,933,984 3,564,440 12,594,135 973,232 24,065,791 7,257,900 3,419,552 12,425,746 977,008 24,080,206 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 1,995,225 4,264 2,021,241 4,020,730 20,152,797 $ 2,103,437 (12,427) 2,405,590 4,496,600 22,663,537 $ 2,215,736 (14,508) 2,808,425 5,009,653 23,366,229 $ 2,315,988 (19,582) 2,942,359 5,238,765 25,974,400 $ 2,439,773 (25,600) 3,288,885 5,703,058 27,218,632 $ 2,566,365 (20,352) 3,559,535 6,105,548 30,171,339 $ 2,677,972 (41,246) 4,224,779 6,861,505 30,941,711 $ 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 $ 2,935,532 (47,054) 5,520,816 8,409,294 35,059,910 $ 3,127,813 (34,072) 6,241,012 9,334,753 37,175,281 $ 3,303,482 (1,147) 7,030,988 10,333,323 38,622,543 $ 3,447,698 44,398 7,573,144 11,065,240 39,280,359 $ Netflix: Operating Budget Q1 Var +/- Var % Budget Projection Next Q Revenue Sales Revenue Net income Investment Income Other Income [Prior Quarter] $6,644,442 $542,156| TOTAL INCOME [Prior Quarter] Budget Projection Next Q Var +/- Var % Costs and Expenses Advertising Technology and development General and Admin Interest expense Operating income Interest and other income (expenses) Income before taxes Benefit from income taxes $762,565 $486,936 $275,539 $197.186 $954,242 $250,639 $861,460 $35,739 TOTAL EXPENSES NET PROFIT/LOSS Net Earnings Before Taxes (Gain or Loss) Income Tax Expense Net Earnings After Taxes [Prior ] Prei. Q. Change Ratio Analysis (Choose a minimum of two) Profitability Ratio Liquidity Ratio Solvency Ratio Valuation Ratio Leverage Ratio in thousands, except per share data) ths Ended September 30, 2019 December 31, 2019 Twelve Months Ended December 31, 2019 March 31, 2020 Three Months Ended June 30, September 30, December 31, 2020 2020 2020 Twelve Months Ended December 31, 2020 $ 5,244,905 $ 3,097,919 553,797 379,776 233.174 980,239 5,467,434 $ 3,466,023 878,937 409,376 254,586 458,512 20,156,447 $ 12,440,213 2,652,462 1,545,149 914,369 2,604,254 5,767,691 $ 3,599,701 503,830 453,817 252,087 958,256 6,148,286 $ 3,643,707 434,370 435,045 277,236 1,357,928 6,435,637 $ 3,867,751 527,597 453,802 271,624 1,314,863 6,644,442 $ 4,165,160 762,565 486.936 275,539 954,242 24,996,056 15,276,319 2,228,362 1,829,600 1,076,486 4,585,289 Revenues Cost of revenues Marketing Technology and development General and administrative Operating income Other income (expense): Interest expense Interest and other income (expense) Income before income taxes Benefit from (provision for) income taxes Net income Earnings per share: Basic Diluted Weighted average common shares outstanding: Basic Diluted (160,660) 192,744 1,012,323 (347,079) 665,244 $ (177,801) (131,378) 149,333 437,637 586,970's (626,023) 84,000 2,062,231 (195,315) 1,866,916 $ (184,083) 21,697 795,870 (86,803) 709,067 $ (189,151) (133,175) 1,035,602 (315,406) 720,196 $ (197,079) (256,324) 861,460 (71,484) 789,976 $ (197,186) (250,639) 506,417 35,739 542,156 $ (767,499) (618,441)|| 3,199,349 (437,954) 2,761,395 $ $ $ 1.52 $ 1.47 $ 1.34 $ 1.30 $ 4.26 $ 4.13 S 1.61 $ 1.57 $ 1.63 $ 1.59 $ 1.79 $ 1.74 $ 1.23 $ 1.19 $ 6.26 6.08 438,090 451,552 438,547 451,367 437,799 451,765 439,352 452,494 440,569 453,945 441,526 455,088 442,220 455,283 440,922 454,208 G H | K L M N O Q R March 31, June 30, 2018 September 30, 2018 December 31, 2018 March 31, 2019 June 30, 2019 September 30, 2019 December 31, 2019 March 31, 2020 June 30, 2020 September 30, 2020 December 31, 2020 2018 $ 3,348,557 $ 5,004,247 $ 4,435,018 $ 5,018,437 $ 5,151,884 $ 7,153,248 $ 8,392,391 $ 8,205,550 2,593,666 $ 4,626,522 597,388 7,817,576 11,300,469 341,932 692,820 20,152,797 $ 3,906,357 $ 4,803,663 636,869 9,346,889 12,279,519 349,646 687,483 22,663,537 $ 3,067,534 $ 4,987,916 674,531 8,729,981 13,397,672 371.152 867,424 23,366,229 $ 3,794,483 $ 5,151,186 748,466 9,694,135 14,951,141 418,281 910,843 25,974,400 $ 820,350 4,168,907 20,878,317 434,372 1,737,036 27,218,632 $ 872,910 5,877,157 21,937,845 452,399 1,903,938 30,171,339 $ 892,740 5,327,758 23,227,772 481,992 1,904,189 30,941,711 $ 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 $ 1,295,897 6,447,781 25,266,889 650,455 2,694,785 35,059,910 $ 1,410,891 8,564,139 25,155,117 751,941 2,704,084 37,175,281 $ 1,434,089 9,826,480 25,067,633 828,118 2,900,312 38,622,543 $ 1,556,030 9,761,580 25,383,950 960,183 3,174,646 39,280,359 $ ABCDE 1 Netflix, Inc. 2 Consolidated Balance Sheets 3 lunaudited) 4 lin thousands) 5 6 7 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Current content assets, net 12 Other current assets 13 Total current assets 14 Non-current content assets, net 15 Property and equipment, net 16 other non-current assets 17 Total assets 18 Liabilities and Stockholders' Equity 19 Current liabilities: 20 Current content liabilities 21 Accounts payable 22 Accrued expenses and other liabilities 23 Deferred revenue 24 Short-term debt 25 Total current liabilities 26 Non-current content liabilities 27 Long-term debt 28 Other non-current liabilities 29 Total liabilities 30 Stockholders' equity: 31 Common stock 32 Accumulated other comprehensive income (loss) 33 Retained earnings 34 Total stockholders' equity 35 Total liabilities and stockholders' equity 36 $ 4,459,391 $ 436,183 436,121 673,892 4,537,578 $ 448,219 396,104 697,740 4,609,055 $ 441,427 531,035 716,723 4,681,562 $ 562,985 481,874 760,899 4,858,899 $ 439,496 750,720 808,692 4,846,525 $ 442,194 752,488 892,777 4,857,520 $ 444,129 1,040,745 915,506 4,413,561 $ 674,347 843,043 924,745 4,761,585 S 545,488 1,061,090 986,753 498,809 7,853,725 3,206,051 14,170,692 1,420,148 26,650,616 4,664,733 $ 446,668 986,595 1,029,261 499,161 7,626,418 3,208,164 15,294,998 1,710,948 27,840,528 4,429,536 656,183 1,102,196 1,117,992 499,878 7,805,785 2,618,084 15,809,095 1,982,155 28,215,119 6,005,587 3,444,476 6,542,373 139,631 16,132,067 6,079,641 3,604,158 8,342,067 141,071 18,166,937 6,298,240 3,593,823 8,336,586 127,927 18,356,576 4,599,654 $ 541,298 1,259,124 1,040,202 499,517 7,939,795 2,926,574 15,547,616 1,875,235 28,289,220 6,487,320 3,759,026 10,360,058 129,231 20,735,635 6,857,807 3,560,364 10,305,023 792,380 21,515,574 6,933,984 3,564,440 12,594,135 973,232 24,065,791 7,257,900 3,419,552 12,425,746 977,008 24,080,206 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 1,995,225 4,264 2,021,241 4,020,730 20,152,797 $ 2,103,437 (12,427) 2,405,590 4,496,600 22,663,537 $ 2,215,736 (14,508) 2,808,425 5,009,653 23,366,229 $ 2,315,988 (19,582) 2,942,359 5,238,765 25,974,400 $ 2,439,773 (25,600) 3,288,885 5,703,058 27,218,632 $ 2,566,365 (20,352) 3,559,535 6,105,548 30,171,339 $ 2,677,972 (41,246) 4,224,779 6,861,505 30,941,711 $ 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 $ 2,935,532 (47,054) 5,520,816 8,409,294 35,059,910 $ 3,127,813 (34,072) 6,241,012 9,334,753 37,175,281 $ 3,303,482 (1,147) 7,030,988 10,333,323 38,622,543 $ 3,447,698 44,398 7,573,144 11,065,240 39,280,359 $