Ratio Computations and Additional Analysis) Bradburn Corporation was formed 5 vears aqo hrough a public subscription of common stock. Daniel Brown, who owns of the common stock, was one of the organizers of Bradburn and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10.2014 Daniel Brown approached the Topeka National Bank, asking for a 24 -month extension on two June 30, 2015, and September 30, 2015. Another note of notes, which are due on |is due on March 31, 2016, but he are due primarily to the company's desire to finance a 2 fiscal years through internally generated funds. (3) Inventory turnover for fiscal year 2015. (4) Return on assets for fiscal years 2014 and 2015. (Assume total assets were at March 31, 2013.) \begin{tabular}{|l|r|r|} \hline Add: Title & Amount & Amount \\ \hline Deduct: Title & Amount & Amount \\ \hline Note repayment & Amount & \\ \hline Funds available for plant expansion & Formula & Formula \\ \hline Plant expansion & Amount & Amount \\ \hline Excess funds & Formula & Formula \\ \hline \end{tabular} Assumptions: Sales increase at a rate of Cost of goods sold increases at rate of despite depreciation remaining constant. Other operating expenses increase at the same rate experienced from 2012 to 2013 ; i.e., at Depreciation remains constant at Dividends remain at per share. Plant expansion is financed equally over the two years each year). Loan extension is granted. vasn uivuetius wele pald at the rate or $1 per share in $ iscal year 2014 and $2 per share in fiscal year 2015. This Excel assignment is not completed in Connect. Be sure to upload vour file to this dropbex. Bradbum Corporation was formed 5 years ago through a public subscription of common stock. Daniel Erown, who owns 15% of the common stock, was one of the organiaters of Bracburn and is the current president. The compary has been successful, but it currently is experiencing a shortage of funds On June 10 , 2014, Daniel Brown approached the Fopela Nationar Bank, akins for 224 - thonth extention on two $35,000 notes, which are due of June 30,2015 , and September 30.2015 . Another note of 56,000 is due on March 31.2016 , but the compary anticiputes no diffculty in paying this note on its due date Brown explained that Eradtourn a cavh flow probilens are due primsilly to the compary s desire to finance a $300.000 plant opansion over the next 2 fiscal vears throcigh internally kenerated funds proper crilk 1 Curmet atio for hical wars 2014 ind 2015 (d) Should Topeka National Bank grant the extension on Bradburn's notes considering Daniel Brown's (5) Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal yea 2014 to 2015. Omit " 000 " from the values. (2) Acid-test (quick) ratio for fiscal years 2014 and 2015. Fill in the provided matrix and utilize it as the matrix for "VLOOKUP" formulas within the cells below. (c) Assume that the percentage changes experienced in fiscal year 2015 as compared with fiscal year 2014 for sales and cost of goods sold will be repeated in each of the next 2 years. Is Bradburn's desire to finance the plant expansion from internally generated funds realistic? Discuss. Ratio Computations and Additional Analysis) Bradburn Corporation was formed 5 vears aqo hrough a public subscription of common stock. Daniel Brown, who owns of the common stock, was one of the organizers of Bradburn and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10.2014 Daniel Brown approached the Topeka National Bank, asking for a 24 -month extension on two June 30, 2015, and September 30, 2015. Another note of notes, which are due on |is due on March 31, 2016, but he are due primarily to the company's desire to finance a 2 fiscal years through internally generated funds. (3) Inventory turnover for fiscal year 2015. (4) Return on assets for fiscal years 2014 and 2015. (Assume total assets were at March 31, 2013.) \begin{tabular}{|l|r|r|} \hline Add: Title & Amount & Amount \\ \hline Deduct: Title & Amount & Amount \\ \hline Note repayment & Amount & \\ \hline Funds available for plant expansion & Formula & Formula \\ \hline Plant expansion & Amount & Amount \\ \hline Excess funds & Formula & Formula \\ \hline \end{tabular} Assumptions: Sales increase at a rate of Cost of goods sold increases at rate of despite depreciation remaining constant. Other operating expenses increase at the same rate experienced from 2012 to 2013 ; i.e., at Depreciation remains constant at Dividends remain at per share. Plant expansion is financed equally over the two years each year). Loan extension is granted. vasn uivuetius wele pald at the rate or $1 per share in $ iscal year 2014 and $2 per share in fiscal year 2015. This Excel assignment is not completed in Connect. Be sure to upload vour file to this dropbex. Bradbum Corporation was formed 5 years ago through a public subscription of common stock. Daniel Erown, who owns 15% of the common stock, was one of the organiaters of Bracburn and is the current president. The compary has been successful, but it currently is experiencing a shortage of funds On June 10 , 2014, Daniel Brown approached the Fopela Nationar Bank, akins for 224 - thonth extention on two $35,000 notes, which are due of June 30,2015 , and September 30.2015 . Another note of 56,000 is due on March 31.2016 , but the compary anticiputes no diffculty in paying this note on its due date Brown explained that Eradtourn a cavh flow probilens are due primsilly to the compary s desire to finance a $300.000 plant opansion over the next 2 fiscal vears throcigh internally kenerated funds proper crilk 1 Curmet atio for hical wars 2014 ind 2015 (d) Should Topeka National Bank grant the extension on Bradburn's notes considering Daniel Brown's (5) Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal yea 2014 to 2015. Omit " 000 " from the values. (2) Acid-test (quick) ratio for fiscal years 2014 and 2015. Fill in the provided matrix and utilize it as the matrix for "VLOOKUP" formulas within the cells below. (c) Assume that the percentage changes experienced in fiscal year 2015 as compared with fiscal year 2014 for sales and cost of goods sold will be repeated in each of the next 2 years. Is Bradburn's desire to finance the plant expansion from internally generated funds realistic? Discuss
