Can anybody help me how to solve this problem, even just how to start it? Thank you. Please help!!!
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 +