PLEASE ANSWER WITH FORMULAS INCUDED IN THE CELLS
Ise the following checklist for the Proforma SLAs. After you are "done" with your SLA, you should run through this list. you need to go back and make changes, you should run through this list again after you make changes. Repeat this process until your SLA is truly complete \& accurate. 1 The Excel file is properly named with the SLA \#, your first initial, your last name. For example, my SLA 1 would be named "SLA 1 DAbelli". note: do not use the symbol \# in your file name, it creates problems opening from Blackboard. Do rename as noted; otherwise file name too long \& can't open when I download from Blkbd 2. Forecast columns F, G, and H are 100% formula and/or linked formula; no manual entries or copy/paste of values (except perhaps Cash) not using formulas and linking means the work is not accurate 3 I have calculated CASH, the final item after I completed all other items not calculating Cash means you are not done, SLA is incomplete 4 I have checked that the Forecast balance sheet is in balance (A=L+SE) if A do not equal L+SE you are not done, SLA is incomplete. Review your work to find any errors; collaborate (not cheat) with other students and utilize Peer Leaders to help with this SLA 5 I have formatted all cells that contain figures properly and appropriately. All dollar amounts have proper comma placement, and dollar sign placement if applicable xx,xxx or $xx,xxx All figures presented without 0 's after decimal (no pennies if dollars; at least two decimals for all ratios and multiples xx.xx All percentages have proper percent sign placement xx.xx\% The cell is the proper size to allow the entire number to show without modification by the instructor (fix any column widths before submission) 6 I certify this SLA file of the completed assignment is my work. I did not receive this completed file from anyone else. working collaborativley with other students is acceptable; passing of another person's work as your own is not 7 My worksheets are visually appealing, easy to read/understand, and in good form as required S33 1,789 shares at January 31,2021 ; outstanding: 1,035 shares at January 30,2022 and 1,077 shares at 29 January 31, 2021 30 Paid-in capital 31 Retained earnings 32 Accumulated other comprehensive loss Treasury stock, at cost, 757 shares at Januar 33 and 712 shares at January 31,2021 34 Wotal stockholders' equity 35 Total liabilities and stockholders' equity Font Alignmer Ise the following checklist for the Proforma SLAs. After you are "done" with your SLA, you should run through this list. you need to go back and make changes, you should run through this list again after you make changes. Repeat this process until your SLA is truly complete \& accurate. 1 The Excel file is properly named with the SLA \#, your first initial, your last name. For example, my SLA 1 would be named "SLA 1 DAbelli". note: do not use the symbol \# in your file name, it creates problems opening from Blackboard. Do rename as noted; otherwise file name too long \& can't open when I download from Blkbd 2. Forecast columns F, G, and H are 100% formula and/or linked formula; no manual entries or copy/paste of values (except perhaps Cash) not using formulas and linking means the work is not accurate 3 I have calculated CASH, the final item after I completed all other items not calculating Cash means you are not done, SLA is incomplete 4 I have checked that the Forecast balance sheet is in balance (A=L+SE) if A do not equal L+SE you are not done, SLA is incomplete. Review your work to find any errors; collaborate (not cheat) with other students and utilize Peer Leaders to help with this SLA 5 I have formatted all cells that contain figures properly and appropriately. All dollar amounts have proper comma placement, and dollar sign placement if applicable xx,xxx or $xx,xxx All figures presented without 0 's after decimal (no pennies if dollars; at least two decimals for all ratios and multiples xx.xx All percentages have proper percent sign placement xx.xx\% The cell is the proper size to allow the entire number to show without modification by the instructor (fix any column widths before submission) 6 I certify this SLA file of the completed assignment is my work. I did not receive this completed file from anyone else. working collaborativley with other students is acceptable; passing of another person's work as your own is not 7 My worksheets are visually appealing, easy to read/understand, and in good form as required S33 1,789 shares at January 31,2021 ; outstanding: 1,035 shares at January 30,2022 and 1,077 shares at 29 January 31, 2021 30 Paid-in capital 31 Retained earnings 32 Accumulated other comprehensive loss Treasury stock, at cost, 757 shares at Januar 33 and 712 shares at January 31,2021 34 Wotal stockholders' equity 35 Total liabilities and stockholders' equity Font Alignmer
