Nicoles Gateway Spa (NGS). Your team of 4-5 members has been hired by Nicole Gateway Spa as their Financial Consultants. NGS is going through changes and would like your advice in the form of a report on several accounting topics. When preparing the report, consider the ratios and interpretation of profitability, solvency, and liquidity. The written recommendation to NGS should cover the following topics: CLO 1: As a small business, NGS has made changes in their Accounts Receivable Policy in the past year. But Nicole is unsure whether the changes have made a difference. Calculate 2021 and 2020 Days to Collect Receivable and Receivables Turnover. Evaluate the short-term solvency for NGS based on the year-over-year change. Provide recommendations for Accounts Receivable policies that could reduce the days to collect. CLO 2: NGS is considering purchasing a tanning bed for $15,000 to add a new service to her business. Nicole was not aware that there were different methods for calculating amortization. Nicole would like to understand the difference between each method, and which method is suitable for her business. Calculate amortization and record the journal entry for Year 1 using the following methods: Straight line methodology assuming a useful life of 10 years. Double declining methodology assuming a rate of 10%. Units of production methodology, where a total of 500 uses. Nicole forecasts that the tanning bed will be used 50 times in Year 1. What is the difference between the three methods? Advise NGS which amortization methodology is suitable for her business and why. CLO 3: NGS is owned by Nicole, who is a sole proprietor. NGS has recently heard about incorporation. Advise NGS as what are the advantages for having a corporation. Calculate NGSs return on assets and return on equity for 2021 and 2020. Explain what the change in each ratio means. CLO 4: NGS has been growing in revenue over the past three years. NGS would like to expand to a new location, but NGS does not have enough funding for expansion. NGS would like to explore options to raise funds through incurring debt. Explain the three options of raising financing available to NGS: Bank Loan Corporate Bond Private Capital A bank loan focuses on two ratios: Debt-to-Assets Ratio and Times Interest Earned Ratio. Calculate these two ratios for 2021 and 2020. Explain to NGS as to what these two ratios represent. The bank requires a Debt-to-Asset ratio of less than one. Explain the Debt-to-Asset ratio for NGS, and whether NGS will meet the bank criteria or not. CLO 6: NGS wants a financial analysis of its performance for 2021 and 2020. Note: express analysis as percentage. Calculate the horizonal analysis for the balance sheet and income statement. Discuss the results of the horizontal analysis. Calculate the vertical analysis for the balance sheet and income statement. Discuss the results of the vertical analysis. This Case Study is worth 30% of your overall grade. It will allow you to demonstrate your understanding of the following concepts covered during Days 1-5 and 7: CLO 1: Demonstrate an understanding of temporary investments, accounts receivable, and bad debts. CLO 2: Analyze the effects of various factors on financial statements. CLO 3: Demonstrate and apply an understanding of shareholder's equity section of the balance sheet including capital contributions and dividends. CLO 4: Analyze corporate debt transactions and explain its impact on financial statements. CLO 6: Analyze financial statement information using ratios and other techniques. You should organize your document professionally with appropriate sections that are ordered in a logical manner, a title page, a table of content, and a list of references (preferably following APA formatting). You will have the opportunity to discuss this case study with your group members and ask your instructor questions during class, any day before the deadline. If you have questions about any of your answers for this assignment, make sure to bring them to your instructors attention. The assignment is due before class on Day 8. Financial Data (can also be found on page 294 of your textbook): Financial Data (can also be found on page 294 of your textbook): Textbook photo