Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have attached 9 photos that all are a part of the problem. Thanks so much! On January 1, Pulse Recording Studlo (PRS) had the
I have attached 9 photos that all are a part of the problem. Thanks so much!
On January 1, Pulse Recording Studlo (PRS) had the following account balances. The following transactions occurred during January. a. Recelved $2,480 cash on 1/1 from customers on account for recording services completed in December. b. Wrote checks on 1/2 totaling $4,200 for amounts owed on account at the end of December. c. Purchosed and recelved supptles on account on 1/3, at a total cost of $200. d. Completed $3,900 of recording sessions on 1/4 that customers had paid for in advance in December. e. Received $4,900 cash on 1,5 from customers for recording sessions started and completed in January. f. Wrote a check on 1/6 for $4,080 for an amount owed on account. g. Converted $1,050 of cash equivalents into cash on 1/7. h. On 1115, completed EFTs for $1,430 for employees' salarles and wages for the first half of January. 1. Recelved $2.850 cash on 1/31 from customers for recording sessions to start in February. 1. Prepare joumal entries for the January transactions. Revlew the 'General Ledger' and the unadjusted 'Trial Balance' Tabs to see the effect of the transactions on the account balances. 2. Prepare journal entrles for items (n)-(n) from the bank reconcillation. 1. The bank deducted $500 for an NSF check from a customer deposited on January 5 . k. The check written January 6 has not cleared the bank, but the January 2 payment has cleared. 1. The cash recelved and deposited on January 31 was not processed by the bank until February 1 m. The bank added $4 cash to the account for interest earned in January n. The bank deducted $4 for service charges. 3. Prepare adjusting journal entries on 1/31 in 'General Journal' Tab. (these are shown as items 15 to 21) 0. Depreciation for the month is $140. p. Salaries and wages totaling $2,100 have not yet been recorded for January 16 to 31 c. Prepaid Rent wil be fully used up by March 31 . i. Supplies on hand at January 31 were $600 s. Recelved $500 involce for January electricity charged on account to be paid in February but is not yet recorded. t interest on the promissory note of $56 for January has not yet been recorded or pald u income tax or $1,200 on January income has not yet been recorded or paid. 4. Review the adjusted 'Trial Balance' as of January 31 . 5. Prepare an income statement for the perlod ended January 31 in the 'Income Statement' Tab 6. Prepore a bank reconciliation in the 'Bank Reconcilation' Tab. 7. Prepare a classifled balance sheet as of January 31 in the 'Balance Sheet' Tob. 8 . Using the information from the tequirements above, complete the 'Analysis' tob. Prepare the journal entries to record transactions (a) through (n). Then prepare the necessary adjusting entries (o) through (u) to correctly report net income for the period. (If no entry is required for a transaction/event, select "No journal entry required" in the first. acoount field.) Journal entry worksheet Received $2,480 cash on 1/1 from customers on account for recording services completed in December. Record the transaction. Noter finter debits bofore credies. General Ledger Account \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Cash } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline 8 & January 01 & & & 3,760 \\ \hline a 1 & January 01 & 2,480 & & 6.240 \\ \hline a 2 & January 02 & & 4,200 & 2,040 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Cash Equivalents } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline 3 & January 01 & & 34 & 1.560 \\ \hline \multicolumn{5}{|c|}{ Supplies } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline 8 & January 01 & & 8 & 530 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline No. & Date & Debit & Credit & Balance \\ \hline 78 & January 01 & 84 & 28 & 7,100 \\ \hline a 1 & January 01 & & 2,480 & 4,620 \\ \hline \end{tabular} Equipment \begin{tabular}{|r|c|r|r|r|} \hline \multicolumn{5}{|c|}{ Prepaid Rent } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 3,150 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|r|r|} \hline No. & Date & Debit & Credit . & Balance \\ \hline & January 01 & & & 30,300 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Accumulated Depreciation-Equipment } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 6.200 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Deferred Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline- & January 01 & & 1 & 3.900 \\ \hline & 2a2 & x2=2 & a. & \\ \hline & & Comme & & \\ \hline No. & Date & Debit & Credit & Bslance \\ \hline & January 01 & in & & 10,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Notes Payable (long-term) } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 12,200 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Accounts Receivable } & \multicolumn{5}{|c|}{ Supplies } \\ \hline No. & Date & Debit & Credit & Balance & No. & Date & Debit & Credit & Balance \\ \hline (1) & January 01 & & & 7,100 & 8 & January 01 & & 8 & 530 \\ \hline 1 & January 01 & & 2,480 & 4,620 & & & & & \\ \hline \multicolumn{10}{|c|}{\begin{tabular}{l} Prepaid Rent \\ \end{tabular}} \\ \hline \multirow[t]{4}{*}{ No. } & Date & Debit & Credit & Balance & \multirow{2}{*}{\begin{tabular}{|l|} No. \\ \\ \end{tabular}} & Date & \multirow{3}{*}{ Debit } & Credit & Balance \\ \hline & January 01 & & & 3,150 & & January 01 & & 8 & 30,300 \\ \hline & 2 & & & & & & & & \\ \hline & \multicolumn{4}{|c|}{ Accumulated Depreciation-Equipment } & \multicolumn{4}{|c|}{ Accounts Payable } & \multirow[b]{2}{*}{ Balance } \\ \hline \multirow[t]{4}{*}{ No. } & Date & Debit & Credit & Balance & No. & Date & Debit & Credit & \\ \hline & January 01 & & 28 & 6.200 & \multirow[b]{2}{*}{ (1) 2} & January 01 & & 8 & \multirow{2}{*}{\begin{tabular}{r} 8,300 \\ 4,100 \\ \end{tabular}} \\ \hline & & & & & & January 02 & 4,200 & & \\ \hline & & \multicolumn{2}{|c|}{ Deferred Revenue } & & \multicolumn{4}{|c|}{ Notes Payable (long-term) } & \\ \hline \multirow[t]{4}{*}{ No. } & Date & Debit & Credit & Balance & \multirow{2}{*}{ No. } & Date & \multirow[t]{2}{*}{ Debit } & Credit & Balance \\ \hline & January 01 & z1 & 18 & 3.900 & & January 01 & & & 12,200 \\ \hline & & & & & & 3 & & & \\ \hline & & Commons & & & & & Retained Ear & nos & \\ \hline No. & Date & Debit & Credit & Bslance & No. & Date & Debit & Credit & Balance \\ \hline & January 01 & 8= & 8 & 10,000 & & January 01 & & 8 & 5.800 \\ \hline \end{tabular} Pulse Recording Studio Trial Balance January 01, 2021 \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Pulse Recording Studio } \\ \hline \multicolumn{2}{|c|}{ Income Statement } \\ \hline For the Month Ended January 31 \\ \hline & \\ \hline & \\ \hline & \\ \hline & 0 \\ \hline & \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline & 0 \\ \hline \end{tabular} Calculate the current ratio at January 31 . (Round your answer to 2 decimal places.) Current Ratio Indicate whether PRS has met its loan covenant that requires a minimum current ratio of 1.2 . \begin{tabular}{l} Calculate the net profit margin at January 31. \\ (Round your answer 102 decimat places) \\ Net Profit Margin \\ Indicate whether PRS has achieved its objective of 10 percent. \\ \hline \end{tabular} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started