I need help with this accounting excel assignment. The instructions is in the first tab of the spreadsheet.

Be advised, the template workbooks and worksheets are not protected. Overtyping any data may remove it. Extensive detail and information is contained within the help function of Microsoft Excel and in the provided text. You should enter your name, date, instructor's name, and course into the cells at the top of the page. This information will be printed on the top of each page if the template requires more than one page. Each template is set to print with File Name, Page # of # Page(s), the print date, and the print time to assist in assembly of multiple pages. If more than one page is required by the template, manual page breaks have been set to provide consistent presentation. All of the cells have been correctly formatted for presentation and should not require any adjustment. For example, if the text requires one, two, or three significant digits in a presentation, the template has been set for that presentation in the appropriate cells. In general, the highlighted cells are the cells which work and effort should be presented. These entries may include date(s), account title(s), values, memorandum appropriate to the entry, or text answers to questions. And information or data which may be required by the solution will be entered in cells with borders to help identify them. Where a highlighted cell shows "Date" enter the appropriate date for that step of the challenge. This may be any date format that Microsoft Excel accepts. Some of these formats include "1/1/12", "01/01/12", and "01/01/2012." All of these will return January 01, 2012, in the format set in the template. Where a highlighted cell shows "Acct Nbr" enter the appropriate account number, provided in the template and in the text for that step of the challenge. This is entry may be a "Look to" formula to another cell where that information has been provided or previously entered. Where a highlighted cell shows "Account Title" enter the appropriate account title for that step of the challenge. This is a text entry and most of those cells are set for the proper indentation for that step. Frequently the chart of accounts appropriate to the challenge is provided and you can use the "look to" formula to reference the appropriate account title without typing it. Check with your instructor to see if abbreviated account titles are acceptable. For example "A/R" for Accounts Receivable, "A/P" for Accounts Payable. If your instructor is using a comparison process between workbooks for grading, these abbreviates may not be acceptable. Where a highlighted cell shows titles such as "Values," "Amounts," or "Quantities" enter the appropriate numerical value for that step of the challenge. The cell is formatted for proper presentation of the entered information. If a dollar sign is appropriate, it should not be entered, Microsoft Excel will place it there through formatting. Commas and significant digits (decimals) are also set through formatting for common presentation. Since the formatting of the templates is not protected by any password, you may change any of the formatting found in the templates to meet your desires. Where a highlighted cell shows titles such as "Formula" you may enter the appropriate formula or enter a numerical value appropriate for that step of the challenge. Most of the values necessary for the appropriate formula are located on the template in cells with borders or in other yellow highlighted cells. The formula may be a simple "Look to" formula, an equal sign and a cell reference, "=E27" or more complex as "=E27*5," or something similar to the time-value-of-money formula. These are addressed in the tutorial text provided for Microsoft Excel. Where a highlighted cell shows "Text" enter the appropriate text for that step of the challenge. This may be a memorandum entry for a journal entry or a lengthy text answer discussing the results of an analysis of a company's financials. These titles can simply be typed over. Where a highlighted cell shows titles such as "Journal Number" or "Journ #" you should enter the appropriate number provided in the template and in the text for that step of the challenge. In general this will appear in instances such as "Record the following events in General Journal number six." The print area is defined to fit onto 8 1/2" 11" sheets in portrait or landscape mode as required. Margins are generally set to no less than 1/2" so most printers can print them without a problem. If you printer cannot accept margins less than 1" you may have to reformat the margins through Page Setup. The display may have "Freeze Pane" invoked so column titles remain visible during data entry. This can be removed by utilizing the View menu and selecting "Unfreeze Panes" under "Freeze Panes." When negative values are required, enter them by starting with a minus sign, "-". Negative values may be shown as ($400) or -$400. Negative values in formulas can be created by putting a minus sign in front of the cell reference - "=E10*-E11" will return a negative value if both cells E10 and E11 contain positive values. Name: Instructor: Date: Course: Ratio Computations and Additional Analysis) Bradburn Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% 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 $35,000 notes, which are due on June 30, 2015, and September 30, 2015. Another note of $6,000 is due on March 31, 2016, 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 financial reports for the last 2 fiscal years. BRADBURN CORPORATION Statement of Financial Position March 31 Assets Cash Notes receivable Accounts receivable (net) Inventories (at cost) Plant & equipment (net of depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Notes payable Accrued liabilities Common stock (130,000 shares, $10 par) 2015 $18,200 148,000 131,800 105,000 1,449,000 $1,852,000 2014 $12,500 132,000 125,500 50,000 1,420,500 $1,740,500 $79,000 76,000 9,000 1,300,000 $91,000 61,500 6,000 1,300,000 Retained earningsa 388,000 282,000 Total liabilities and stockholders' equity $1,852,000 $1,740,500 a Cash dividends were paid at the rate of $1 per share in fiscal year 2014 and $2 per share in fiscal year 2015. BRADBURN CORPORATION Income Statement For The Fiscal Year Ended March 31 Sales Cost of goods sold Gross margin Operating expenses Income before income taxes 2015 $3,000,000 1,530,000 1,470,000 860,000 610,000 2014 $2,700,000 1,425,000 1,275,000 780,000 495,000 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 3 of 18, 10/11/2017, 13:25:55 Name: Instructor: Income taxes Net income after income taxes Date: Course: 244,000 $366,000 198,000 $297,000 Depreciation charges on the plant and equipment of $100,000 and $102,500 for the fiscal years ended March 31, 2014, and 2015, respectively, are included in cost of goods sold. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 4 of 18, 10/11/2017, 13:25:55 Name: Instructor: Date: Course: Instructions: Fill in the provided matrix and utilize it as the matrix for "VLOOKUP" formulas within the cells below. Column 4 2015 Formula Formula Formula Formula Amount Amount Amount Amount Amount Amount Amount Amount Amount Average inventory - 2015 Average total assets Total Assets = Mar 31, 2013 Total Assets = Mar 31, 2014 Total Assets = Mar 31, 2015 Cost of goods sold Current assets Current liabilities Dividends Depreciation Gross margin Income before taxes Income taxes (40%) Inventories = EOY 2014 Inventories = EOY 2015 Net income after taxes Operating expenses Sales Amount Amount Amount Amount Column 5 2014 Formula Amount Amount Amount Amount Amount Amount Amount Amount Amount Amount Amount Amount (a) Compute the following items for Bradburn Corporation: (1) Current ratio for fiscal years 2014 and 2015. 2014 Current ratio = Current assets ----------------------- = Current liabilities Amount ---------------- = Amount Formula 2015 Current ratio = Current assets ----------------------- = Current liabilities Formula ---------------- = Formula Formula (2) Acid-test (quick) ratio for fiscal years 2014 and 2015. 2014 Quick ratio = Current assets - Inventories ----------------------- = Current liabilities Formula ---------------- = Formula 2015 Quick ratio = Current assets - Inventories ----------------------- = Current liabilities Formula ---------------- = Formula (3) Inventory turnover for fiscal year 2015. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 5 of 18, 10/11/2017, 13:25:55 Name: Instructor: Date: Course: 2015 Inventory Turnover = Cost of goods sold ------------------------------------ = Average inventory Amount ---------------- = #N/A 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 6 of 18, 10/11/2017, 13:25:55 Name: Instructor: Date: Course: (4) Return on assets for fiscal years 2014 and 2015. (Assume total assets were at March 31, 2013.) $1,688,500 2014 Return on assets = Net income ----------------------- = Average total assets Formula ---------------- = Formula Formula 2015 Return on assets = Current assets ----------------------- = Current liabilities Formula ---------------- = Formula Formula (5) Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year 2014 to 2015. Omit "000" from the values. 2014 2015 Change Percent Change Formula Sales Formula Formula Formula Cost of goods sold Formula Formula Formula Formula Gross margin Formula Formula Formula Formula Net income after taxes Formula Formula Formula Formula Note: The formulas in some cell formulas are "live" and need values placed in their source cells. (b) Identify and explain what other financial reports and/or financial analyses 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. Other financial reports and financial analyses which might be helpful to the commercial loan officer of Spokane National Bank include: 1 Enter text answer as appropriate. 2 Enter text answer as appropriate. 3 Enter text answer as appropriate. 4 Enter text answer as appropriate. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 7 of 18, 10/11/2017, 13:25:55 Name: 4 Instructor: Enter text answer as appropriate. Date: Course: 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 8 of 18, 10/11/2017, 13:25:55 Name: Instructor: Date: Course: (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. Enter text answer as appropriate. Sales Title Gross margin Title Income before taxes Title Net income 2015 Formula Formula Formula Formula Formula Formula Formula Add: Title Deduct: Title Note repayment Funds available for plant expansion Plant expansion Excess funds 2016 Formula Formula Formula Formula Formula Formula Formula 2017 Formula Formula Formula Formula Formula Formula Formula Amount Amount Amount Formula Amount Formula Amount Amount Formula Amount Formula 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( Loan extension is granted. each year). (d) Should Topeka National Bank grant the extension on Bradburn's notes considering Daniel Brown's statement about financing the plant expansion through internally generated funds? Discuss. Enter text answer here. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 9 of 18, 10/11/2017, 13:25:55 Enter text answer here. Name: Instructor: Date: Course: 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 10 of 18, 10/11/2017, 13:25:55 o of the ny has been n approached the s, which are due on , 2016, but he low problems er the next iscal years. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 11 of 18, 10/11/2017, 13:25:55 s sold. 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 12 of 18, 10/11/2017, 13:25:55 elow. to 1 to 1 Formula to 1 Formula to 1 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 13 of 18, 10/11/2017, 13:25:55 Formula to 1 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 14 of 18, 10/11/2017, 13:25:55 es from fiscal year r source cells. o the time extension icer of Spokane 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 15 of 18, 10/11/2017, 13:25:55 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 16 of 18, 10/11/2017, 13:25:55 cal year 2014 desire to o 2013; i.e., at h year). Brown's statement 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 17 of 18, 10/11/2017, 13:25:55 36ff197df8775f0d221f159b13d3ee3f6078fe4f.xlsx, Module 8-Profitability, Page 18 of 18, 10/11/2017, 13:25:55