Could you please help me with this excel problem? I attached 3 pictures below with both Part A (Real world interest disclosures) and Part B (Financial Statement impacts of interest - 2 pics) of the excel worksheet. Thank you so much for your help. I appreciate that!
Home Insert Draw Page Layout Formulas Data Review View AA ap Wrap Text v Paste B I UVV OVAv Merge & Center v $ % Conditional Format Formatting as Table B4 X v fx |'Create a unique three-year, par value loan by choosing reasonable values for the following items. Answer the questions below related to the I A B D E F G UNH PART B - FINANCIAL STATEMENT IMPACTS OF INTEREST Create a unique three-year, par value loan by choosing reasonable values for the following items. Answer the questions below related to the loan's impact on the financial statements for the borrower. The loan should be issued during 2020, sometime after January 1, and interest should be payable annually. Use formulas for all cells containing dollar amounts, except for the input cells below. Inputs: LD 00 Face Value Interest Rat Date of Issuance (e.g. 4/1/2020) 10 11 What is the loan's impact on earnings? Year Ended December 31, 2020 Year Ended December 31, 2021 Account Name: 12 Overall Dollar Value of Impact to Earnings (Ignore) taxes): 13 14 15 What is the loan's impact on cash flow? Year Ended December 31, 2020 Year Ended December 31, 2021 Operating Impact (Dollar Amount): 16 Investing Impact (Dollar Amount): 17 Financing Impact (Dollar Amount): 18 Overall Impact to Cash Flow (Dollar Amount): A SUMMARY PART A A PART B +Home Insert Draw Page Layout Formulas Data Review View A A 25 Wrap Text v Paste BI U Y Y OVAv E E Merge & Center $ * % " Conditional Format Formatting as Table B4 X v fx |'Create a unique three-year, par value loan by choosing reasonable values for the following items. Answer the questions below related to the loa A B C D E F G Overall Dollar Value of Impact to Earnings (Ignore taxes) 13 14 What is the loan's impact on cash flow? Year Ended December 31, 2020 Year Ended December 31, 2021 Operating Impact (Dollar Amount): 16 nvesting Impact (Dollar Amount): 17 Financing Impact (Dollar Amount): 18 Overall Impact to Cash Flow (Dollar Amount): 19 20 What is the loan's impact on the Balance Sheet? Remember the impact to Balance Sheet elements is cumulative, because the accounts are Year Ended December 31, 2020 Year Ended December 31, 2021 permanent. 21 Asset Impact (Dollar Amount): 22 Liability Impact (Dollar Amount): 23 Equity Impact (Dollar Amount): 24 25 A SUMMARY & PART A A PART B +Home Insert Draw Page Layout Formulas Data Review View " A A ab Wrap Text v Paste BI U V Y OVAv Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Style B1 X V fx PART A - REAL WORLD INTEREST DISCLOSURES A B D E F G Choose two of the companies listed below. Review the financial statements and relevant disclosures and answer the following questions for each company. 4 Choose one from the following list: McDonald's 2018 Form 10-K, Disney's 2018 Form 10-K, Nordstrom 2018 Form 10-K (For the year ended February 3, 2019). Company Name: How much cash was paid for interest during the most recent fiscal year? How much interest expense is included on the most recent fiscal year income statement? 10 How much interest was capitalized during the most recent fiscal year, if any? 11 Using your understanding of GAAP accounting for interest, briefly explain why the answers to questions 1 and 2 are not the same. 12 Provide a brief summary (1 paragraph or less) in your own words of the company's long-term debt and related interest commitments according to its long-term note disclosure A SUMMARY A PART A A PART B +
