90.2K

Verified Solution

Link Copied!

Receivables and Revenue Account for notes receivable On May 31, 2018, Wyoming State Bank loaned money to Lindsey Weston on a note with the following features: $ 240,000 Loan value Maturity (years) Use the blue shaded areas on the ENTERANSWERS tab for inputs Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong Requirements 1 Compute the amount of interest during 2018, 2019, and 2020 for the note receivable Enter all amounts as positive values Do not round intermediate calculations a. b. 2 Determine which party has a note receivable, a note payable, an interest revenue, an interest expense 3 How much in total would Wyoming State Bank collect if Lindsey Weston paid off the note early on November 30, 2018? a. Enter the amount as a positive value Saving & Submitting Solution 1 Save file to desktop a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add -solution-date to end of file name 2 Upload and submit your file to be graded a.Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open C. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback

Answer & Explanation Solved by verified expert

See Answer