How do I get the 2021 Balance Sheet given the following data from 2020 and Income statement Budget

+ Sample Excel Cash---Budget Illus C A docs.google.com/spreadsheets/d/1SsDmj4gbo2tl2uksX24tyUiyelgc8nUG/edit#gid=1372973025 Sample Excel Cash---Budget Illustration5.19.22C35B .XLSX * @ @ B Share File Edit View Insert Format Data Tools Help Last edit was 26 minutes ago 100% * $ % .0 .00 123- Calibri 11 B IS A Q B E - E - 1 . H . V . C P . Y - E- B239 fx Building and equipment K LM N O P Q R S T U v w X 179 180 181 Income Statement Budget 182 2021 183 Sales (5050 units x P120) 606,000.00 184 Less: Variable expenses Tax rate is 32% 185 Variable cost of sales (5050 units x P78) 393,900.00 186 Variable selling and administrative expenses 30,300.00 187 Contribution Margin 181,800.00 188 Less: Fixed expenses 189 Fixed factory overhead 60,000.00 190 Fixed selling and administrative expenses 48,000.00 108,000.00 191 Net income before interest and income tax 73,800.00 192 Less: interest expense 1,560.00 193 Net income before income tax 72,240.00 194 Less: income tax (32%) 23,116.80 195 Net income 49,123.20 196 197 198 Balance Sheet 199 2020 200 Assets 201 Current Assets 202 Cash 10,000.00 203 Accounts Receivable 14,250.00 204 Raw materials Inventory 1,590.00 205 Finished goods inventory 4,040.00 206 9,880.00 207 Non-current assets 208 Land 80,000.00 209 Building and equipment 150,000.00 210 Accumulated depreciation -90,000.00 211 140,000.00 212 213 Total Assets 179,880.00 214 215 Current liabilities 216 Accounts payable 3,300.00 217 Income tax payable 6,000.00 218 9,300.00 219 220 Stockholders' equity 221 Common stock, no par 114,999.00 222 Retained earnings 55,581.00 223 170,580.00 224 225 Total Liabilities and stockholders' equity 179,880.00 226 227 228 Balance Sheet 229 2021 230 Asset 231 Current Assets 232 rach 25 100 70 Sheet1 Type here to search 29C Mostly cloudy ~ @ @ 0 24 ENG 25/05/2022+ Sample Excel Cash---Budget Illus C A docs.google.com/spreadsheets/d/1SsDmj4gbo2tl2uksX24tyUiyelgc8nUG/edit#gid=1372973025 Sample Excel Cash---Budget Illustration5.19.22C35B .XLSX * @ @ B Share File Edit View Insert Format Data Tools Help Last edit was 26 minutes ago no @ 7 100% $ % .0 .00 123- 11 BISA Q B E - E. I . H . V . CO P Y - E- B23 fx Building and equipment K LM N O P Q R S T U v w X 215 Current liabilities 216 Accounts payable 3,300.00 217 Income tax payable 6,000.00 218 9,300.00 219 220 Stockholders' equity 221 Common stock, no par 114,999.00 222 Retained earnings 55,581.00 223 70,580.00 224 225 Total Liabilities and stockholders' equity 179,880.00 226 227 228 Balance Sheet 229 2021 230 Assets 231 Current Assets 232 Cash 25,108.70 233 Accounts Receivable 52,200 234 Raw materials Inventory 235 Finished goods inventory 236 237 Non-current assets 238 Land 239 Building and equipment 240 Accumulated depreciation Accumulated depreciation, additional P50,000 241 242 243 Total Assets 244 245 Current liabilities 246 Accounts payable 247 Income tax payable 248 249 250 Stockholders' equity 251 Common stock, no par 252 Retained earnings 253 254 255 Total Liabilities and stockholders' equity 256 257 258 259 Cash, beginning balance 10,000.00 260 Add: expected cash receipts 537,750.00 261 Total cash available 547,750.00 262 Less: expected cash payments 521,081.30 263 Cash surplus 26,668.70 264 Less: Interest expense on financing 1,560.00 265 Budgeted cash, ending balance 25,108.70 266 267 Sheet1 - Type here to search 29C Mostly cloudy ~ @ @ 0 2 4 ENG 25/05/2022