Calculating LIFO, FIFO, Income and Cash Flows

An acquaintance has proposed the following business plan to you. A local company requires a consistent quantity of a commodity and is looking for a reliable supplier. You could become that reliable supplier.

The cost of the commodity is expected to rise steadily over the foreseeable future, but the company is willing to pay more than the price that is current at the time. All you would need to do is make an investment, purchase the inventory and then deliver inventory to the company over the following year. One complication is that the commodity is available for purchase only seasonally, so at the end of every year you would need to purchase the supply for the following year. The customer pays promptly on delivery.

An initial cash investment of $62,000 would be used to purchase $50,000 of inventory in December 2019. The remaining cash would be held for liquidity needs. In the following year, you would deliver this inventory to the customer. Inventory costs are expected to increase by $10,000 per year, and the customer agrees to pay $15,000 more than the current cost of inventory. So, during 2020, you would deliver inventory that originally cost $50,000, receive payment of $75,000 and pay $60,000 to purchase inventory for the current year. This pattern would continue in future years, but with annually increasing costs of inventory and corresponding increases in the price charged the customer.

If you accept this proposal, your objective would be to receive $9,000 in dividends (about a 15% return on the $62,000 investment) at the end of each year. Assume your business would have an income tax rate of 40%.

a. Construct a projected balance sheet as of the end of December 2019.

b. Construct financial forecasts of income statements, cash flows (direct method) and balance sheets for the next three years (through 2022). Assume that your business would operate in a tax jurisdiction that requires the use of FIFO for inventory.

c. Construct financial forecasts of income statements, cash flows (direct method) and balance sheets for the next three years (through 2022). Assume that your business would operate in a tax jurisdiction that requires the use of LIFO for inventory.

Projected Balance Sheet Financial Statement Forecasts - FIFO Financial statement Forecasts - LIFO Balance Sheet December 2019 Assets Cash $ 12,000 Inventory 50,000 Total assets to 62,000 Shareholders' equity Contributed capital $ 62,000 Previous Save AnswersIncome statement: 2021 Revenue $ 75,000 $ 85,000 $ 95,000 COGS-LIFO 50,000 70,000 80,000 Earnings before tax 15,000 15,000 15,000 Tax expense 0 0 0 Net income 35 15,000 $ 15,000 $ 15,000 Cash ows: Receipts $ 0 $ 0 $ 0 Inventory purchases 0 0 0 Tax payments 0 0 0 Cash from operations 0 0 0 Dividends 0 0 0 Cash from financing 0 0 0 Net change in cash $ 0 $ 0 $ 0 Balance sheet: Assets Cash 55 0 $ 0 $ Inventory 0 0 Total 0 0 Shareholders' equity Contributed capital 0 0 Retained earnings 0 0 Total $ 0 $ 0 $ Year Income statement: Revenue COGS-FiFO Earnings before tax Tax expense Net income Cash flows: Receipts Inventory purchases Tax payments Cash from operations Dividends Cash from financing Net change in cash Balance sheet: Assets Cash Inventory Total Shareholders' equity Contributed capital Retained earnings Total 2020 2021 2022 75,000 85,000 95,000 50,000 60,000 70,000 25,000 25,000 25,000 10,000 10,000 10,000 15,000 15,000 15,000 75,000 85,000 95,000 60,000 70,000 80,000 10,000 10,000 10,000 5,000 5,000 5,000 9,000 9,000 9,000 (9,000) (9,000) (9,000) (4,000) (4,000) (4,000) 8,000 4,000 0 60,000 70,000 80,000 68,000 74,000 80,000 62,000 62,000 62,000 15,000 21,000 27,000 68,000 74,000 80,000