Prepare a financial and business analysis of Tootsie Roll Industries, Inc. (1,500 to 2,750 words) in order to secure a loan for the company. The loan will increase the company’s total liabilities by 10%. The contents of the plan should include the following:
1. Prepare a financial analysis (spreadsheet) in Excel using the company’s financial statements. The spreadsheet should include historical financial statements (balance sheet and income statement), projected financial statements (balance sheet and income statement), a three year ratio analysis of the company’s historical financial statements, and a three year ratio analysis of the company’s projected financial statements. The accounting periods for the historical and projected analysis are provided at the beginning of week three. The ratio analysis should include several types of liquidity, solvency, and profitability ratios. Incorporate industry comparisons with your ratio analysis and list your assumptions. Submit the final spreadsheet with your team’s paper.
2. Prepare a business plan that includes a synopsis, market and sales analysis, product line narrative, funding request/purpose of loan and a financial summary using the results from your spreadsheet. It is important to collaborate with everyone on the team and discuss how the request/purpose of the loan will impact each section of the business plan. Incorporate your discussions and conclusions in each section of the plan.
Additional details and guidance are provided via the week three projects thread. Format your paper consistent with APA guidelines and submit your paper, Excel spreadsheet and Turnitin report via the assignment files tab.
Need help with this assignment or a similar one? Place your order and leave the rest to our experts!