ACC 318 Module Six Assignment Template Complete this template by replacing the bracketed text with the relevant information. Calculations 1. Calculate the current ratio for fiscal years 2025 and 2026. [Insert text.] 2. Calculate the acid test (quick ratio) for fiscal years 2025 and 2026. [Insert text.] 3. Calculate the inventory turnover for the fiscal year 2026. [Insert text.] 4. Calculate the return on assets for fiscal years 2025 and 2026. (Assume that total assets were $1,688,500 at 3/31/24.) [Insert text.] Percentage Changes 1. Calculate the percentage change in sales from the fiscal year 2025 to 2026. [insert text.] 2. Calculate the percentage change in cost of goods sold from the fiscal year 2025 to 2026 . [insert text.] 3. Calculate the percentage change in gross margin from the fiscal year 2025 to 2026. [Insert text.] 4. Calculate the percentage change in net income after taxes from the fiscal year 2025 to 2026. [insert text.] Financial Decisions and Factors 1. Describe at least one additional financial report or analysis that might be helpful to the commercial loan officer of Topeka National Bank in evaluating Daniel Brown's request for a time extension on Bradburn's notes. [insert text.] 2. Explain whether Bradburn's desire to finance the plant expansion from internally generated funds is realistic. Assume that the percentage changes experienced in fiscal year 2026 as compared with fiscal year 2025 for sales, cost of goods sold, and operating expenses will be repeated in each of the next two years. Consider the following question to guide your response: A. What will the percentage changes for sales, cost of goods sold, and operating expenses look like in each of the next two years? B. How does the percentage change for sales, cost of goods sold, and operating expenses affect Bradburn's ability to finance the plant expansion from internally generated funds? [Insert text.] 3. Explain whether Topeka National Bank should grant the extension on Bradburn's notes considering Daniel Brown's statement about financing the plant expansion through internally generated funds. Consider the following question to guide your response: A. Should Topeka National Bank grant the loan? Why or why not? B. Will Bradburn's projected operations for 2027 generate an adequate amount of cash to finance the plant expansion and repay the loan? C. Does Bradburn need the 24-month extension? Why or why not? D. What do the financial ratios indicate about Bradburn's financial structure? [Insert text.] eferences clude any references used to complete this assignment. This section is for the full citation. Sources hould be cited using APA style.[Insert text.] F*223.3 (L0 6,8) A textbox reads, Excel. A textbox reads, Groupwork. (Ratio Computations and Additional Analysis) Bradbum Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% 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, 2026, Daniel Brown approached the Topeka National Bank, asking for a 24 -month extension on two $35,000 notes, which are due on June 30, 2026, and September 30,2026. Another note of $6,000 is due on March 31,2027 , but he expects no difficulty in paying this note on its due date. Brown explained that Bradburn's cash flow problems are due primarily to the company's desire to finance a $300,000 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. Bradburn Corporation Balance sheet March 31 a-Cash, dividends were paid at the rate of $1 per share in fiscal year 2025 and $2 per share in fiscal year 2026. Bradburn Corporation Income Statement For the Fiscal Years Ended March 31 a-Depreciation charges on the plant and equipment of $100,000 and $102,500 for fiscal years ended March 31,2025 and 2026, respectively, are included in cost of goods sold. ACC 318 Module Six Assignment Template Complete this template by replacing the bracketed text with the relevant information. Calculations 1. Calculate the current ratio for fiscal years 2025 and 2026. [Insert text.] 2. Calculate the acid test (quick ratio) for fiscal years 2025 and 2026. [Insert text.] 3. Calculate the inventory turnover for the fiscal year 2026. [Insert text.] 4. Calculate the return on assets for fiscal years 2025 and 2026. (Assume that total assets were $1,688,500 at 3/31/24.) [Insert text.] Percentage Changes 1. Calculate the percentage change in sales from the fiscal year 2025 to 2026. [insert text.] 2. Calculate the percentage change in cost of goods sold from the fiscal year 2025 to 2026 . [insert text.] 3. Calculate the percentage change in gross margin from the fiscal year 2025 to 2026. [Insert text.] 4. Calculate the percentage change in net income after taxes from the fiscal year 2025 to 2026. [insert text.] Financial Decisions and Factors 1. Describe at least one additional financial report or analysis that might be helpful to the commercial loan officer of Topeka National Bank in evaluating Daniel Brown's request for a time extension on Bradburn's notes. [insert text.] 2. Explain whether Bradburn's desire to finance the plant expansion from internally generated funds is realistic. Assume that the percentage changes experienced in fiscal year 2026 as compared with fiscal year 2025 for sales, cost of goods sold, and operating expenses will be repeated in each of the next two years. Consider the following question to guide your response: A. What will the percentage changes for sales, cost of goods sold, and operating expenses look like in each of the next two years? B. How does the percentage change for sales, cost of goods sold, and operating expenses affect Bradburn's ability to finance the plant expansion from internally generated funds? [Insert text.] 3. Explain whether Topeka National Bank should grant the extension on Bradburn's notes considering Daniel Brown's statement about financing the plant expansion through internally generated funds. Consider the following question to guide your response: A. Should Topeka National Bank grant the loan? Why or why not? B. Will Bradburn's projected operations for 2027 generate an adequate amount of cash to finance the plant expansion and repay the loan? C. Does Bradburn need the 24-month extension? Why or why not? D. What do the financial ratios indicate about Bradburn's financial structure? [Insert text.] eferences clude any references used to complete this assignment. This section is for the full citation. Sources hould be cited using APA style.[Insert text.] F*223.3 (L0 6,8) A textbox reads, Excel. A textbox reads, Groupwork. (Ratio Computations and Additional Analysis) Bradbum Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% 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, 2026, Daniel Brown approached the Topeka National Bank, asking for a 24 -month extension on two $35,000 notes, which are due on June 30, 2026, and September 30,2026. Another note of $6,000 is due on March 31,2027 , but he expects no difficulty in paying this note on its due date. Brown explained that Bradburn's cash flow problems are due primarily to the company's desire to finance a $300,000 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. Bradburn Corporation Balance sheet March 31 a-Cash, dividends were paid at the rate of $1 per share in fiscal year 2025 and $2 per share in fiscal year 2026. Bradburn Corporation Income Statement For the Fiscal Years Ended March 31 a-Depreciation charges on the plant and equipment of $100,000 and $102,500 for fiscal years ended March 31,2025 and 2026, respectively, are included in cost of goods sold