Prepare an analysis of the assigned company (1500 – 2,000 words) in order to secure a loan for the company. The loan will increase the company’s total liabilities by 3%. The contents of the project include the following: Discuss the loan amount and how you plan to use the loan proceeds. Use the Excel Spreadsheet provided and complete the following. a. Prepare a five-year vertical analysis of the company’s income statement. Prepare a projected income statement for 2020 and 2021 assuming sales increase by 3% and 6%. Compute the ratios listed with the income statement. Compute the ratios listed with the balance sheet. Using the results of your spreadsheet, what questions would you ask the CFO of the company? Explain. The assigned company, spreadsheet, detailed instructions, and guidance are provided during week three. see the following and complete the attached excel sheet. Financial Analysis: Open the Excel spreadsheet provided. Prepare a vertical analysis of Bridgford’s income statement. Enter the percentages in columns C, E, G, I, and K. For additional information regarding vertical analysis, please review the following. Vertical Analysis Prepare: a projected income statement assuming sales increase by 3% in 2020 and 6% in 2021. Average your vertical analysis percentages for each income statement account and enter the results in column L, rows 5 – 11. Example: Add columns C, E, G, I and K and divide by 5. (64.07+60.58+63.17+67.57+67.34)/5=64.55%. Column L, row 5 = 64.55%. Enter your projected sales number in columns M & N, row 4. Columns M and N: Multiply projected sales by the average percentage for each income statement account. Ratio Computations. Use Excel formulas to calculate financial ratios listed with the income statement and balance sheet tabs. Calculate ratios for seven years (i.e. 2015-2021). Do not prepare ratios that require data from the 2020 and 2021 balance sheet. In this case, “N/A” is entered in the appropriate cell. For additional information regarding ratios, please review the following. Financial Ratios Note: If there is a discrepancy between the formula used in our text versus the formula included with the above link, use the formula incorporated with the above link. Loan: The written section of the project includes a loan discussion and CFO questions and explanations. Use the following resources to complete your analysis. Form 10-K Corporate Annual and Earnings Report Chief Financial Officer Questions: Using the results of your spreadsheet, what questions would you ask the CFO of Bridgford Foods? Explain. Format your paper consistent with APA guidelines. Deliverables: Paper (MS Word) and Excel Spreadsheet. Review your Originality Report generated from SafeAssign. A new originality report is created with each attempt. Your last attempt is used for grading.
At Assignments123.com, we value our customers and always strive to deliver nothing but the best 100% original papers. Our assignment help services guarantee that you will get the best high-quality work done by certified, highly trained writers. All the information that you share with us is also kept completely confidential. At Assignments123.com, we guarantee you quality service at the most affordable price and absolute confidentiality.
Assignments123.com provides you with 100% original work of the highest quality. Our custom assignment writing service is the best in the assignment help industry. We also have a money-back guarantee policy that customers can use in case you do not feel contented with the final product that we deliver. We always strive to ensure that our money-back guarantee is totally transparent and legal in all ways. So, the next time you hire one of our writers but feel that the paper was substandard, you can always request for your money back.Read more
As the leading custom assignment writing service, every product that you order with Assignments 123 will always be original. All of the orders that our writers submit must pass through multiple advanced anti-plagiarism programs to ensure that the product that we deliver to your inbox is 100% original. Assignments123.com has zero-tolerance for plagiarism. You can rest assured that every paper that we deliver to our clients will be plagiarism-free. That’s part of what makes us the best custom assignment writing service in the industry.Read more
Our free revision policy is a service that Assignments123.com also provides to ensure that all our customers are completely satisfied with the orders that we deliver. The entire process is also very simple and straightforward. And all you need to do is to request for revision from our customer support team. We will link you with your writer to have your paper revised to your specifications. Our team of expert writers will strive to amend, add, or omit any sectors of your paper as you require.Read more
As the best custom assignment writing service across the globe, Assignments123.com is committed to protecting all of its customers’ personal information. We will never share with or resell any of our customers’ personal information under any circumstance. You can, therefore, rest assured that your credit card data, name, and other personal information will never end up in the hands of a third-party player. We also process all your online transactions through secure and reliable online payment methods. You can trust that we will keep your information safe and secure at all times.Read more
Assignments123.com is the best custom writing assignment company in the world with many reasons to match our claim. By placing your order with us, you also agree to use the services that we provide. As a result, we also endear to ensure that we deliver the best comprehensive finished paper as per your requirements. Likewise, we count on our customers’ cooperation to help us deliver on this mandate. We will work together to ensure that we provide you with nothing but the highest quality papers.Read more