In this task you will prepare a report for the chief financial officer (CFO) to present to a bank vice president who may consider extending a long-term loan to Custom Snowboards, Inc. The CFO has requested that you analyze the financial statements to arrive at a selection of key financial statement line items, a risk assessment and ratios that the banker may use to assess and, if the loan is granted, track the progress of the company’s ability to repay the loan.
You will prepare another report to present directly to the chief executive officer (CEO) of Custom Snowboards Inc. and the board of directors. The report will include a recent history of the company and arecommendation on how to proceed with the expansion plans. Be sure to enter your first initial and last name on the first worksheet in Custom Snowboards, Inc. Financial Data excel document. Task: Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 5 work. When you enter your first initial and last name at the top of the Income Statement you are given a dataset that is based on your name. The evaluator will need a copy of your data to ensure correct evaluation.
A. Create a report for the chief financial officer in which you do the following:
1. Summarize the key points of the company’s financial picture that could impact the bank officer’s decision. Note: A variety of analyses that will provide a solid understanding of the highlights of the financial statements should be included. 2. Explain how any financial risks pointed out by the bank loan officer could be mitigated by the company.
3. Analyze the ratios that will indicate the ability to repay the principal and interest on the 5-year loan. B. Create a report with your recommendations on the European expansion of Custom Snowboards Inc. for the chief executive officer (CEO) by doing the following:
1. Present a historical analysis of past performance.
a. Analyze what the historical