Excel File Edit View Insert Format Tools Data Window Help NI itulli AutoSavo McNamara, TTH12 Home Insert Draw Page Layout Formulas Data Review View X Calibri (tody) 12 - AA 29 Wrap Text Genera a. Au Marge Center $ Recover Unsaved Workbooks. We were able to serve changes to one or more flies. Do you want to recover them? * Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates A1 x fx Current and contingent Liabilities A o H 1 Currenl and Contingent Liabilities 2 Record note payable transactions F 1 Dean Sales Company completed the following note payable transactions 6 7 2018 Jul 1 Purchased delivery truck costing $ 58,000 Dec 31 Accrued interest on the note payable. by issuing a one-year, 4% note payable 10 2019 11 Id 1 Paid the note payable at maturity 12 13 Use the blue shaded areas on the ENTERANSWERS tab for inputs Always use cell references and formulas where appropriate to rective full credit. If you copy/paste from the Instructions tan you will be marked 14 wrong 15 16 Requirements 1 How much interest expense must be accrued at December 31, 2018? IR 2 Determine the amount of Dean Sales' final payment on July 1, 2019 19 3 How much interest expense will Dean Sales report for 2018 and for 2019? 12 22 Saving & Submitting Solution 1 Save file to desktop Create folder on desktop, and label COMPLETED EXCEL PROJECTS 25 2 Upload and submit your file to be graded 20 Navigate back to the activity window screen where you downloaded the initial spreadsheet Click Choose button under step locate the file you just saved and click Open Click Upload button under step d Click Submit button under step 4 30 INSTRUCTIONS ENTERANSWERS C Soest destination and press ENTER or choose Paste Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 LE AA == Pasta B I U a. Av Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you w Office Update To keep up-to-date with security updates, fixes, and improvements, choose C B4 x fx B s A c 1 1. How much interest expense must be accrued at December 31, 2018? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 2 from the Instructions tab you will be marked wrong.) Accrued interest, Dec 31, 2018 6 2. Determine the amount of Dean Sales' final payment on July 1, 2019. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Final payment on July 1, 2019 11 3. How much Interest expense will Dean Sales report for 2018 and for 2019? (Always use cell references and formulas where appropriate to receive full credit. If you copy paste 13 from the instructions tab you will be marked wrong.) 13 14 Interest expense for 2018 15 Interest expense for 2019 20 17 19 21 26 27 21 INSTRUCTIONS UNTERSWERS Sanct testinition Emphasis Heading 1 Heeding 2 Normal Grader - Instructions Account TTH 12e E8-13A v3 Project Description: tth 12.08.13a Steps to Perform: Step Instructions 1 How much interest expense must be accrued at December 31, 2018? (Always use celi references and formulas where appropriate to receive full credit. If you copy paste from the Instructions tab you will be marked wrong.) Determine the amount of Dean Sales final payment on July 1, 2019. (Always use cell references and formulas where appropriate to receive full credit. If you copy paste from the instructions tab you will be marked wrong.) How much interest expense will Dean Sales report for 2018 and for 2019? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong) 3
