all parts please. most of it is right just need cleaning up.

Required information [The following information applies to the questions displayed below.] In this Applying Excel exercise you will practice using basic formulas and absolute cell referencing to caiculate and record interest on Notes Receivable. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. Revise your calculations based the new information provided below and then answer the questions that follow. A company lends $354,000 to an owner and accepts a three year, 7% note in return. The note was issued on June ist of the current. year, and will be due on June ist of the final year of the note. Required: (a) Prepare the journal entry to be made when the company makes the loan and accepts the note in return, (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) (b) Calculate the interest revenue to be recorded at the end of each year the note is outstanding. (c) Prepare the journal entries to accrue the interest receivable for each year the note is outstanding. (if no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) (d) Prepare the journal entry to record recelving the cash at the note's maturity. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.)