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. Complete the budget template using thisOperating Budget TemplateDownload Operating Budget Template:

• 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. Review the online articleAnalyze Investments Quickly With Ratios(Links to an external site.)(Elmerraji, 2017) and Chapter 5 in the Abraham's textbook to help with this portion of the budget:

• Profitability Ratio
• Liquidity Ratio
• Solvency Ratio
• Valuation Ratio

Powered by Clearbit Deere & Co. (NYS: DE) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date 10/31/2021 11/01/2020 11/03/2019 10/28/201 10/29/201 Currency USD USD USD USD USD Audit Status Not Not Not Not Not Qualified Qualified Qualified Availabl Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousan Thousan ds ds Cash & cash equivalents 8017000 7066000 3857000 3904000 9334900 Marketable securities 728000 641000 581000 490100 451600 Receivables from unconsolidated affiliates 27000 31000 46000 21700 35900 Trade accounts & notes receivable - agricultural & turf 2881000 3224000 3210000 2991000 Trade accounts & notes receivable - production & precision ag 1204000 Trade accounts & notes receivable - small ag & turf 1683000 Trade accounts & notes receivable - construction & forestry 1321000 1290000 2006000 1794000 934000 Trade accounts & notes receivable - net 4208000 4171000 5230000 5004300 3924900 Financing receivables - net 33799000 29750000 29195000 27054100 25104 100 Financing receivables securitized - net 4659000 4703000 4383000 4021400 4158800 Taxes receivable 1436000 931000 1231000 1370000 876000 Other receivables 302000 289000 256000 366000 324000 Other receivables 1738000 1220000 1487000 1735500 1200000 Equipment on operating leases - net 6988000 7298000 7567000 7165400 6593700 Raw materials & supplies 3524000 1995000 2285000 2233000 1688000 Work-in-process 994000 648000 747000 776000 495000 Finished goods & parts 4373000 4006000 4613000 4777000 3182000 Total FIFO value 8891000 6649000 7645000 7786000 5365000 Less: adjustment to LIFO value 2110000 1650000 1670000 1637000 1461000 Inventories 6781000 4999000 5975000 6148900 3904100 Land 293000 282000 274000 283000 122000 Buildings & building equipment 4287000 4114000 3976000 3848000 3396000 Machinery & equipment 6123000 5936000 5710000 5570000 5378000Machinery & equipment 6123000 5936000 5710000 5570000 5378000 Dies, patterns, tools, etc 1679000 1662000 1531000 1564000 1647000 All other equipment operations 1165000 1115000 1065000 1032000 942000 Construction in progress 27000 440000 733000 619000 358000 Total at cost 14074000 13549000 13289000 12916000 11843000 Less: accumulated depreciation - equipment operations 8291000 7771000 7360000 7095000 6826000 Total equipment operations property & equipment, net 5783000 5778000 5929000 5821000 5017000 Land 4000 4000 4000 4000 4000 Buildings & building equipment 65000 65000 75000 74000 74000 All other financial services 32000 34000 34000 34000 38000 Total at cost 101000 103000 113000 1 12000 1 16000 Less: accumulated depreciation - financial services 64000 64000 69000 65000 65000 Total financial services property & equipment, net 37000 39000 44000 47000 51000 Property & equipment - net 5820000 5817000 5973000 5867500 5067700 Investments in unconsolidated affiliates 175000 193000 215000 207300 182500 Goodwill 3291000 3081000 2917000 3100700 1033300 Other intangible assets - net 1275000 1327000 1380000 1562400 218000 Retirement benefits 3601000 863000 840000 1298300 538200 Deferred income taxes 1037000 1499000 1466000 808000 2415000 Other assets 1970000 2432000 1899000 1718400 1623600 Total assets 84114000 75091000 73011000 70108000 65786300 Notes payable to banks 273000 192000 345000 464000 221000 Finance lease obligations due within one year 23000 21000 Long-term borrowings due within one year 1213000 79000 642000 970000 154000 Total short-term borrowings-equipment operations 1509000 292000 987000 1434000 375000 Commercial paper 2230000 1238000 2698000 3857000 3439000 Notes payable to banks 63000 182000 313000 344000 157000 Long-term borrowings due within one year 7117000 6870000 6786000 6427000 6064000 Total short-term borrowings-financial services 8290000 9797000 9628000 9660000 Short-term borrowings 10919000 8582000 10784000 11061400 10035300 Short-term securitization borrowings 4605000 4682000 4321000 3957300 4118700 Payables to unconsolidated affiliates 143000 105000 142000 128900 121900 Accounts payable - trade payables 2967000 1926000 1996000 2465000 2069000 Accounts payable - dividends payable 329000 244000 244000 223000 194000 Accounts payable - operating lease liabilities 279000 297000 Accounts payable - other 155000 251000 284000 243000 164000 Accrued expenses - dealer sales discounts 1636000 1682000 1990000 1801000 1559000 Accrued expenses - product warranties 1312000 1105000 1218000 1146000 1007000 Accrued expenses - employee benefits 1448000 1086000 1001000 1038000 861000 Accrued expenses - accrued taxes 933000 730000 734000 836000 Accrued expenses - unearned revenue 825000 679000 657000 665000 520000 Accrued expenses - other 1171000 1114000 1108000 965000 1344000 Total accounts payable & accrued expenses-equipment operations 11055000 9114000 9232000 9382000 7718000 Accounts payable - deposit withheld from dealers & merchants 157000 141000 164000 190000 207000Accounts payable - collateral on derivatives 274000 Accounts payable - other 210000 194000 163000 239000 275000 Unearned revenue 1013000 968000 978000 885000 797000 Accrued interest 165000 181000 211000 163000 148000 Accured expenses - employee benefits 83000 60000 61000 63000 55000 Accrued expenses - other 387000 309000 259000 516000 345000 Total accounts payable & accrued expenses-financial services 2015000 2127000 1836000 2056000 1827000 Eliminations for accounts payable & accrued expenses -865000 -1129000 -1412000 -1327000 -1128000 Accounts payable & accrued expenses 12205000 10112000 9656000 10111000 8417000 Deferred income taxes 576000 519000 495000 555800 209700 Long-term borrowings - equipment operations 8915000 10124000 5415000 4714000 5491000 Medium-term notes 22899000 21661000 23528000 20865000 18601000 Senior note 489000 502000 Other notes 1138000 992000 1335000 1215000 1339000 Less debt issuance costs -43000 -49000 -46000 -42000 Less debt issuance costs & debt discounts -64000 Total long-term borrowings - financial services 23973000 22610000 24814000 22523000 20400000 Long-term borrowings 32888000 32734000 30229000 27237400 25891300 Retirement benefits & other liabilities 4344000 5413000 5953000 5751000 7417900 Total liabilities 65680000 62147000 61580000 58802800 56211800 Redeemable noncontrolling interest 14000 14000 14000 Common stock 5054000 4895000 4642000 4474200 4280500 Common stock in treasury, at cost 20533000 18065000 17474000 16311800 15460800 Retained earnings (accumulated deficit) 36449000 31646000 29852000 27553000 25301300 Retirement benefits adjustment -1034000 3918000 -3915000 -3237000 -3580000 Cumulative translation adjustment -1478000 -1596000 -1651000 -1204000 -999000 Unrealized gain (loss) on derivatives -42000 58000 60000 15000 5000 Unrealized gain (loss) on investments 15000 33000 19000 -2000 10000 Accumulated other comprehensive income (loss) -2539000 -5539000 5607000 -4427600 -4563700 Total Deere & Company stockholders' equity 18431000 12937000 11413000 11287800 9557300 Noncontrolling interests 3000 7000 4000 3400 3200 Total stockholders' equity 18434000 12944000 11417000 11291200 9560500Powered by Clearbit Deere & Co. (NYS: DE) Exchange rate used is that of the Year End reported date As Reported Quarterly Income Statement Report Date 05/01/2022 01/30/2022 08/01/2021 05/02/2021 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter Currency USD USD USD USD Audit Status Unaudited Unaudited Unaudited Unaudited Consolidated Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Net sales 12034000 8531000 10413000 10998000 Finance & interest income 796000 800000 825000 809000 Other income 540000 238000 289000 251000 Total net sales & revenues 13370000 9569000 11527000 12058000 Cost of sales 8918000 6695000 7574000 7928000 Research & development expenses 453000 402000 394000 377000 Selling, administrative & general expenses 932000 781000 841000 838000 Interest expense 187000 229000 244000 268000 Other operating expenses 328000 311000 324000 335000 Total costs & expenses 10818000 8418000 9377000 9746000 Income (loss) of consolidated group before income taxes 2552000 1151000 2150000 2312000 Provision (benefit) for income taxes 461000 250000 491000 530000 Income (loss) of consolidated group 2091000 901000 1659000 1782000 Equity in income (loss) of unconsolidated affiliates 6000 3000 8000 8000 Net income (loss) 2097000 904000 1667000 1790000 Less: net income (loss) attributable to noncontrolling interests 1000 -1000 Net income (loss) attributable to Deere & Company 2098000 903000 1667000 1790000 Weighted average shares outstanding - basic 306200 307400 311000 312800 Weighted average shares outstanding - diluted 308100 309400 313400 315200 Year end shares outstanding 305635.672 306784.327 310061.478 311942.092 Net income (loss) per share - basic 6.85 2.94 5.36 5.72 Net income (loss) per share - diluted 6.81 2.92 5.32 5.68 Dividends declared per common share 1.05 1.05 0.9 0.9Company Name: Operating Budget Q1 [Prior Quarter] Budget Var +/- Var % Revenue Projection Next Q Sales Revenue Interest Income Investment Income Other Income TOTAL INCOME Costs and Expenses [Prior Quarter] Budget Var +/- Var % Projection Next Q) Advertising Health Insurance Installation Repair of Equipment Inventory Purchases SalariesSupplies Insurance Rent/Lease Payments Other Expenses TOTAL EXPENSES NET PROFIT/LOSS Net Earnings Before Taxes (Gain or Loss) Income Tax Expense Net Earnings After Taxes Proj. Q. Change Ratio Analysis (Choose a minimum of two) [Prior Q] Profitability Ratio Liquidity Ratio Solvency Ratio Valuation Ratio