Economics of Fixed Income Markets Case Study – 20210627F

Requirements: 3 pages A project report not to exceed 3 pages in total. Please clearly type or mark your answers to avoid any ambiguity and to facilitate grading. Double check your answers! Please, UPLOAD your completed typed assignment (in Microsoft WORD or PDF and Microsoft EXCEL for calculations) Purpose: The purpose of this project is to provide hands-on opportunity to conduct a simple Credit Risk Analysis (covered in Unit 9, Week 3), using the Altman Z-Score model. Use the information provided in the Excel spreadsheet under the same folder as this handout (see also Week 3 Class Notes) to calculate the Altman’s Z-Score of ZINGA LINK Product, Inc., and comment on your results. Instructions: Use Model 1 in the posted accompanying Excel spreadsheet to predict the probability of financial distress and possibly bankruptcy for ZINGA LINK, assuming ZINGA LINK is a public company. To decide whether ZINGA LINK will experience financial distress or not, refer to the proposed cutoff points, which are part of the models presented on page 1 of the spreadsheet. (Also see posted sample spreadsheet) Based on the results you obtained, assign a likely “Credit Rating,” per Standard & Poors or Moody’sclassification, as discussed in the relevant class material or your own research. Please, provide complete and detailed reference(s) if you use your own researched material or additional sources for the analysis and assignment of a rating. Note that the Altman’s variable X1 involves “Net Working Capital” that equals “Current Assets” less “Current Liabilities”, which you should calculate from the balance sheet for each year. For variable X4, please use the “Book Value of All Assets” as a proxy for “Market Value of All Assets.” The key information for solving this project is presented in the balance sheets and income statements of ZINGA LINK, which appear on page 3 of the Excel spreadsheet. The customary financial ratios are presented on page 2 of the spreadsheet for your reference. The Altman’s Z-Score models, including the definition of the variables, is presented on the first page of the spreadsheet. Also, refer to read the article below for more details about the models. A project report not to exceed 3 pages in total. Please clearly type or mark your answers to avoid any ambiguity and to facilitate grading. Double check your answers!
Please, UPLOAD your completed typed assignment (in Microsoft WORD or PDF and Microsoft EXCEL for calculations) Purpose: The purpose of this project is to provide hands-on opportunity to conduct a simple Credit Risk Analysis (covered in Unit 9, Week 3), using the Altman Z-Score model. Use the information provided in the Excel spreadsheet under the same folder as this handout (see also Week 3 Class Notes) to calculate the Altman’s Z-Score of ZINGA LINK Product, Inc., and comment on your results. Instructions: Use Model 1 in the posted accompanying Excel spreadsheet to predict the probability of financial distress and possibly bankruptcy for ZINGA LINK, assuming ZINGA LINK is a public company.
To decide whether ZINGA LINK will experience financial distress or not, refer to the proposed cutoff points, which are part of the models presented on page 1 of the spreadsheet. (Also see posted sample spreadsheet)
Based on the results you obtained, assign a likely “Credit Rating,” per Standard & Poors or Moody’sclassification, as discussed in the relevant class material or your own research. Please, provide complete and detailed reference(s) if you use your own researched material or additional sources for the analysis and assignment of a rating.
Note that the Altman’s variable X1 involves “Net Working Capital” that equals “Current Assets” less “Current Liabilities”, which you should calculate from the balance sheet for each year. For variable X4, please use the “Book Value of All Assets” as a proxy for “Market Value of All Assets.”
The key information for solving this project is presented in the balance sheets and income statements of ZINGA LINK, which appear on page 3 of the Excel spreadsheet.
The customary financial ratios are presented on page 2 of the spreadsheet for your reference.
The Altman’s Z-Score models, including the definition of the variables, is presented on the first page of the spreadsheet. Also, refer to read the article below for more details about the models.