Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the information from requirements 1 - 7 below assist with requirements 8 - 12: Requirements 8 - 12 are below please assist with these

Using the information from requirements 1 - 7 below assist with requirements 8 - 12:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Requirements 8 - 12 are below please assist with these using information above:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

Requirement \# 11: Ratios Using the data from Income Statement and Balance Sheet prepared by you in step 7 compute the following ratios. Current Ratio Formula Current Assets / Current Liabilities Leverage Ratio Formula Average Total Assets / Average Common Stockholders' Equity Asset Turnover Ratio Formula Net Sales / Average Total Assets Computation Computation Computation Net Profit Margin Ratios Computation Formula Net Income - Preferred Dividends / Net Sales REQUIREMENT \#6: Prepare an Adjusted Trial Balance in the space below. Rate of Return on Total Assets Formula Computation Net Profit Margin Ratio X Assets Turnover Ratio (Net Income - Preferred Dividends/ Net Sales ) X(Net Sales / Average Total Assets) X Alternatively Computation Net Income - Preferred Dividends / Average Total Assets Requirement \#4: Prepare adjusting entries using the following information in the General Journal below. Show your calculations! a) One month's insurance has expired. b) The remaining inventory of repair supplies is $200. c) The estimated depreciation on repair equipment is $150. d) The estimated income taxes are $100. Requirement \#5: Post the adjusting entries on March 31 below to the General Ledger T-accounts and compute adjusted balances. Just add to the balances that are already listed. Chart of Accounts Please enter what each of the ratio results from Spreadsheet 11 mean for the company. General Journal Requirement \#8: Prepare the closing entries at March 31 in the General Journal below. Hint: Use the balances for each account which appear on the Adjusted Trial Balance for your closing entries. Requirement \#9: Post the closing entries to the T-Accounts on the General Ledger worksheet and compute ending balances. Just add to the adjusted balances already listed. \begin{tabular}{|l|l|r|} \hline \multicolumn{1}{|c|}{} & \multicolumn{2}{|c|}{ Common Stock (311) } \\ \hline 1-Mar & & 22,500 \\ \hline Balance & & 22,500 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Electric Expense (517) } \\ \hline 31-Mar & 300 & \\ \hline Balance & & \\ \hline & 300 & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{2}{|c|}{ Retained Earnings (312) } \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} & \multicolumn{2}{|c|}{ Dividends (313) } \\ \hline & 1,000 & \\ \hline 31-Mar & & \\ \hline Balance & 1,000 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \end{tabular} REQUIREMENT \#2: Post the March journal entries to the following T-Accounts and compute ending balances. Requirement \#10: Prepare a post-closing trial balance as of March 31 in the space below. Requirement \#7: Prepare the financial statements for Howard's Flight Radio Management Corporation as of March 31 in the space below. You will only be preparing the Income Statement, Statement of Retained Earning, and the Balance Sheet. The Statement of Cash Flows is a required Financial Statement, but is not required for this project. Howard's Flight Radio Management Corporation Income Statement For the Month Ending March 31 Howard's Flight Radio Management Corporation Statement of Retained Earnings For the Month Ending March 31 Howard's Flight Radio Management Corporation Balance Sheet March 31 \begin{tabular}{|l|r|l|} \hline & \multicolumn{2}{|c|}{ Repair Equipment (144) } \\ \hline 3-Mar & 5,800 & \\ \hline & & \\ \hline Balance & 5,800 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{|c|}{ Accum. Depr.-Repair Equipment (145) } \\ \hline 31-Mar & & 150 \\ \hline Balance & & 150 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline & \multicolumn{2}{|c|}{ Accounts Payable (212) } \\ \hline 18-Mar & 400 & \\ \hline 3-Mar & & 3,600 \\ \hline 8-Mar & & 650 \\ \hline Balance & & 3,850 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{2}{|c|}{ Income Taxes Payable (213) } \\ \hline 31-Mar & & 100 \\ \hline Balance & & 100 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Insurance Expense (513) } \\ \hline 31-Mar & 180 & \\ \hline & & \\ \hline Balance & 180 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Repair Supplies Expense (514) \begin{tabular}{|l|r|l|} \hline 31-Mar & 450 & \\ \hline & & \\ \hline Balance & 450 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & Pepr. Exp.-Repair Equipment (515 \\ \hline 31-Mar & 150 & \\ \hline & & \\ \hline Balance & 150 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Income Taxes Expense (516) } \\ \hline 31-Mar & 100 & \\ \hline & & \\ \hline Balance & 100 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} General Journal March Transactions REQUIREMENT \#3: Prepare a trial balance for March in the space below. Requirement \# 11: Ratios Using the data from Income Statement and Balance Sheet prepared by you in step 7 compute the following ratios. Current Ratio Formula Current Assets / Current Liabilities Leverage Ratio Formula Average Total Assets / Average Common Stockholders' Equity Asset Turnover Ratio Formula Net Sales / Average Total Assets Computation Computation Computation Net Profit Margin Ratios Computation Formula Net Income - Preferred Dividends / Net Sales REQUIREMENT \#6: Prepare an Adjusted Trial Balance in the space below. Rate of Return on Total Assets Formula Computation Net Profit Margin Ratio X Assets Turnover Ratio (Net Income - Preferred Dividends/ Net Sales ) X(Net Sales / Average Total Assets) X Alternatively Computation Net Income - Preferred Dividends / Average Total Assets Requirement \#4: Prepare adjusting entries using the following information in the General Journal below. Show your calculations! a) One month's insurance has expired. b) The remaining inventory of repair supplies is $200. c) The estimated depreciation on repair equipment is $150. d) The estimated income taxes are $100. Requirement \#5: Post the adjusting entries on March 31 below to the General Ledger T-accounts and compute adjusted balances. Just add to the balances that are already listed. Chart of Accounts Please enter what each of the ratio results from Spreadsheet 11 mean for the company. General Journal Requirement \#8: Prepare the closing entries at March 31 in the General Journal below. Hint: Use the balances for each account which appear on the Adjusted Trial Balance for your closing entries. Requirement \#9: Post the closing entries to the T-Accounts on the General Ledger worksheet and compute ending balances. Just add to the adjusted balances already listed. \begin{tabular}{|l|l|r|} \hline \multicolumn{1}{|c|}{} & \multicolumn{2}{|c|}{ Common Stock (311) } \\ \hline 1-Mar & & 22,500 \\ \hline Balance & & 22,500 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Electric Expense (517) } \\ \hline 31-Mar & 300 & \\ \hline Balance & & \\ \hline & 300 & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{2}{|c|}{ Retained Earnings (312) } \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} & \multicolumn{2}{|c|}{ Dividends (313) } \\ \hline & 1,000 & \\ \hline 31-Mar & & \\ \hline Balance & 1,000 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \end{tabular} REQUIREMENT \#2: Post the March journal entries to the following T-Accounts and compute ending balances. Requirement \#10: Prepare a post-closing trial balance as of March 31 in the space below. Requirement \#7: Prepare the financial statements for Howard's Flight Radio Management Corporation as of March 31 in the space below. You will only be preparing the Income Statement, Statement of Retained Earning, and the Balance Sheet. The Statement of Cash Flows is a required Financial Statement, but is not required for this project. Howard's Flight Radio Management Corporation Income Statement For the Month Ending March 31 Howard's Flight Radio Management Corporation Statement of Retained Earnings For the Month Ending March 31 Howard's Flight Radio Management Corporation Balance Sheet March 31 \begin{tabular}{|l|r|l|} \hline & \multicolumn{2}{|c|}{ Repair Equipment (144) } \\ \hline 3-Mar & 5,800 & \\ \hline & & \\ \hline Balance & 5,800 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{|c|}{ Accum. Depr.-Repair Equipment (145) } \\ \hline 31-Mar & & 150 \\ \hline Balance & & 150 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline & \multicolumn{2}{|c|}{ Accounts Payable (212) } \\ \hline 18-Mar & 400 & \\ \hline 3-Mar & & 3,600 \\ \hline 8-Mar & & 650 \\ \hline Balance & & 3,850 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{2}{|c|}{ Income Taxes Payable (213) } \\ \hline 31-Mar & & 100 \\ \hline Balance & & 100 \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Insurance Expense (513) } \\ \hline 31-Mar & 180 & \\ \hline & & \\ \hline Balance & 180 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Repair Supplies Expense (514) \begin{tabular}{|l|r|l|} \hline 31-Mar & 450 & \\ \hline & & \\ \hline Balance & 450 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & Pepr. Exp.-Repair Equipment (515 \\ \hline 31-Mar & 150 & \\ \hline & & \\ \hline Balance & 150 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \multicolumn{1}{c|}{} & \multicolumn{2}{c|}{ Income Taxes Expense (516) } \\ \hline 31-Mar & 100 & \\ \hline & & \\ \hline Balance & 100 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} General Journal March Transactions REQUIREMENT \#3: Prepare a trial balance for March in the space below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trusted Advisors Key Attributes Of Outstanding Internal Auditors

Authors: Richard F. Chambers, President And CEO Of The IIA

1st Edition

0894139819, 978-0894139819

More Books

Students also viewed these Accounting questions