Part 1: Calculating Maturity Dates and Interest 1. For each note below, calculate and record the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 1: Calculating Maturity Dates and Interest 1. For each note below, calculate and record the maturity date and interest. No. of Note Date of Note 1 Mar. 5 Principal $700.00 Interest Rate Time of Note Maturity Date Interest 14% 180 days 2 Mar. 16 $1,500.00 10% 120 days 3 Apr. 12 $650.00 11% 90 days 4 May 9 $1,800.00 12% 60 days (30 points) Part 2: Journalizing Notes Payable and Notes Receivable, Accrued Revenue and Expenses, and Dividend Transactions 1. Journalize the following business transactions. a. Start Microsoft Excel, and open the BUS114_15_03.xlsx file from C:\ACTT2\Data\Unit_15. b. Click the File tab, and click Save As. Save the file to C:\ACTT2\Student\Unit_15. c. Navigate to the appropriate spreadsheet tab for the journal in which you will post. d. Journalize the following transactions: e. i. February 1. Signed a 60-day, 10% note, $5,000.00. R80. ii. iv. V. vi. April 2. Paid cash for the maturity value of the Feb. 1 note: principal, $5,000.00, plus interest, $83.33. C215. April 20. Received cash for the maturity value of Notes Receivable No. 34: principal $500.00, plus interest, $45.00. R78. June 1. Signed a 90-day, 18% note to True North Toilets Corp. for an extension of time on this account payable, $2,500.00. M44. December 15. The board of directors declared a dividend of $5.00 per share; capital stock issued is 3,000 shares. M234. December 31. Paid cash for dividend declared December 15. C345. Save your work and close the spreadsheet or continue to Part 3. Part 3: Preparing a Stockholders' Equity Statement 1. Prepare a statement of stockholders' equity for Al-Can Products, Inc. 2. Navigate to the Stockholders' Equity Statement tab in the spreadsheet. 3. Use the following information to prepare your statement: a. January 1 balance of capital stock account of 9,000 shares issued at $6.00 per share was $54,000.00. b. No other stock was issued during the year. c. January 1 balance of retained earnings account was $29,250.00. d. Net Income was $41,106.00. e. Dividends declared during the year were $19,200.00. 4. Save and close the spreadsheet. 5. Submit to your instructor for grading. Part 1: Calculating Maturity Dates and Interest 1. For each note below, calculate and record the maturity date and interest. No. of Note Date of Note 1 Mar. 5 Principal $700.00 Interest Rate Time of Note Maturity Date Interest 14% 180 days 2 Mar. 16 $1,500.00 10% 120 days 3 Apr. 12 $650.00 11% 90 days 4 May 9 $1,800.00 12% 60 days (30 points) Part 2: Journalizing Notes Payable and Notes Receivable, Accrued Revenue and Expenses, and Dividend Transactions 1. Journalize the following business transactions. a. Start Microsoft Excel, and open the BUS114_15_03.xlsx file from C:\ACTT2\Data\Unit_15. b. Click the File tab, and click Save As. Save the file to C:\ACTT2\Student\Unit_15. c. Navigate to the appropriate spreadsheet tab for the journal in which you will post. d. Journalize the following transactions: e. i. February 1. Signed a 60-day, 10% note, $5,000.00. R80. ii. iv. V. vi. April 2. Paid cash for the maturity value of the Feb. 1 note: principal, $5,000.00, plus interest, $83.33. C215. April 20. Received cash for the maturity value of Notes Receivable No. 34: principal $500.00, plus interest, $45.00. R78. June 1. Signed a 90-day, 18% note to True North Toilets Corp. for an extension of time on this account payable, $2,500.00. M44. December 15. The board of directors declared a dividend of $5.00 per share; capital stock issued is 3,000 shares. M234. December 31. Paid cash for dividend declared December 15. C345. Save your work and close the spreadsheet or continue to Part 3. Part 3: Preparing a Stockholders' Equity Statement 1. Prepare a statement of stockholders' equity for Al-Can Products, Inc. 2. Navigate to the Stockholders' Equity Statement tab in the spreadsheet. 3. Use the following information to prepare your statement: a. January 1 balance of capital stock account of 9,000 shares issued at $6.00 per share was $54,000.00. b. No other stock was issued during the year. c. January 1 balance of retained earnings account was $29,250.00. d. Net Income was $41,106.00. e. Dividends declared during the year were $19,200.00. 4. Save and close the spreadsheet. 5. Submit to your instructor for grading.
Expert Answer:
Related Book For
Engineering Economic Analysis
ISBN: 9780195168075
9th Edition
Authors: Donald Newnan, Ted Eschanbach, Jerome Lavelle
Posted Date:
Students also viewed these accounting questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A particular automatic sprinkler system has two different types of activation devices for each sprinkler head. One type has a reliability of 0.9; that is, the probability that it will activate the...
-
Mass customization is a new trend in production. What technological changes have enabled this trend to take place? What are the advantages and disadvantages of this type of production process...
-
A ski resort chair lift has towers spaced 44m horizontally apart. The upper tower is 13 m higher than the previous tower. If the chairs are 14 m horizontally apart and the first chair is 5 m past...
-
To investigate the performance of a logic circuit for a small electronic calculator, a laboratory puts 75 of the circuits on life test without replacement under specified environmental conditions,...
-
The accounting records of Grayson Architects include the following selected, unadjusted balances at March 31: Accounts Receivable, $ 1,400; Office Supplies, $ 1,100; Prepaid Rent, $ 2,400; Equipment,...
-
We had to read Leader-Member Exchange 'LMX' What Is It and Why You Should Care here:...
-
you are to play the role of a department head and come together with other department heads to discuss the rollout of a new code of ethics handbook that the organization plans to adopt. The new code...
-
What does accounts recieveable turnover show about how efficiently a company manages its assets?
-
A moderate issue with staffing shortages on your program is being tracked. New developers were estimated to be on staff by March8, but appears that this deadline will not be reached. What is the...
-
Amabile and Kramer detail the "progress principle." Identify five "must know" ideas related to the importance of the progress principle. Explain the four major categories of potential communication...
-
What is the Expected Return of Portfolio Fund A, using the weighted average method?
-
prepare the balance sheet for the following: Accumulated depreciation, retaines earnings, cash, bonds payable, accounts receivable, plant and equipment, accounts payable, allowance for bad debts,...
-
Write a note on workplace bullying. Research one aspect of a contemporary social problem Define the problem. Propose a possible solution for the problem. Create an argument that supports your thesis...
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
If sand from gravel pit 1 is used, then molten glass for producing armored glass has a random impurity content \(X\) which is \(N(60,16)\)-distributed. But if sand from gravel pit 2 is used, then...
-
The total monthly sick leave time of employees of a small company has a normal distribution with mean 100 hours and standard deviation 20 hours. (1) What is the probability that the total monthly...
-
Let \(X\) have a geometric distribution with \[P(X=i)=(1-p) p^{i} ; \quad i=0,1, \ldots ; 0
Study smarter with the SolutionInn App