Indigo Corporation was formed 5 years ago through a public subscription of commo
ID: 2596434 • Letter: I
Question
Indigo Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the com mon stock, was one of the organizers of Indigo and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2018, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two $34,930 notes, which are due on June 30, 2018, and September 30, 2018. Another note of $5,940 is due on March 31, 2019, but he expects no difficulty in paying this note on its due date. Brown explained that Indigo's cash flow problems are due primarily to the company's desire to finance a $299,490 plant expansion over the next 2 fiscal years through internally generated funds. The commercial loan officer of Topeka National Bank requested the following financial reports for the last 2 fiscal years. INDIGO CORPORATION BALANCE SHEET MARCH 31 Assets Cash Notes receivable Accounts receivable (net) Inventories (at cost) Plant & equipment (net of depreciation) 2018 2017 $18,210 148,520 131,030 105,670 1,463,200 $1,866,630 $12,550 131,480 124,980 50,450 1,431,100 $1,750,560 Total assets Accounts payable Notes payable Accrued liabilities Common stock (130,000 shares, $10 par) Retained earnings $78,850 75,730 16,310 1,308,430 387,310 $90,930 61,460 20,980 1,297,370 279,820 $1,750,560 1.06,630 ,.75 Total liabilities and stockholders equityExplanation / Answer
2018 2017 Current Ratio(a/b) 2.36 1.84 Current Assets (a) 4,03,430 3,19,460 Current Liabilities (b) 1,70,890 1,73,370 Acid Test Ratio(c/d) 1.74 1.55 Current Assets (c) 2,97,760 2,69,010 Current Liabilities (d) 1,70,890 1,73,370 Stock Turnover Ratio (e/f) 19.70 Cost of Goods Sold (e ) 15,38,040 Average Inventory (f) 78,060 Return on Assets (g/h) 20.15 % 17.83 % Net Income(g) 3,64,380 3,07,272 Average Assets (h) 18,08,595 17,23,260 Sales Revnue (i-j)/j 10.71 % Sales Current year (i) 29,98,210 Sales Last Year(j) 27,08,130 Cost of Good Sold (k-l)/l 8.36 % Cost of Good Sold Current year (k) 15,38,040 Cost of Good Sold Last Year(l) 14,19,360 Gross Margin (m-n)/n 9.81 % Gross Margin Current year (m) 8,52,870 Gross Margin Year(n) 7,76,650 Net Income (o-p)/p 18.59 % Net Income Current year (o) 2,42,920 Net Income Year(p) 2,04,848