Ervilige Producions 50 Sheet Legal Pad Building Blocks of Accounting .. Financial Ratios Page 1 \begin{tabular}{|llllr|} \hline Veraien & First & Last & File & Date \\ \hline 1610 & Jermaine & Forbes & FJS944 & 11/40.22 \\ \hline \end{tabular} All sheets have been locked to protect the "HELP" messages built into this case. Enter the required data into the yellow filled cells on the Rabo sheet. \begin{tabular}{|l|l|} \hline Step 1 & Using the information from: \\ \hline & Post Closing TB (Trial Balance) Last Year \\ \hline Income Statement \\ \hline & Stockholders Equity \\ \hline & Balance Sheet \\ \hline & Cash Flow Statement \\ \hline Glossary Sheet \\ \hline & calculate the financial ratios and answer the open ended questions that are on the Ratio sheet \\ \hline \end{tabular} Step2 Upload the Flle. Jermaine, when you are ready to have your work graded you will upload your file FJ5944 XIS, FJ5944. xlsx or FJ5944.xisb from the botlom of the the same screen that the project was downloaded from. If you have a problem uploading see FAQ01. Ratio 201118 Building Blocks of Accounting w Financial Accounting Ratio Analysis Project In this project you wil calculate 18 financial ratios that help stakeholders determine if a company is a good investment. You will be asked to amwer lour questions related to interpreting and explaining the ratios. You mut complete the raties and the written answers to receive full marks en the project. Keep in mind that there is a Glossary Tab - here you wal find the ratio name and eamponerts Your project will have the following Company inlormation: 1. Balance Sheet, 2020 2. Incore Statement, 2021 3. Statement of 'Stockhalder' Cquity, 2021 4. Balance Sheet, 2021 5. Statemert of Cash Flows, 2021 You will have to complete the "Ratio" sheet Column E - Requies you to select (ffill h or Ink tol the proper numbers from the approcrate financial Szatement Column G - Requeres you to cakulate the rewhing ratio based on the comsonent you sekcted, rounded to two places Example: Par Value of Stock equak 50.01 Reminders about Calculations Average = ( Beginning Elalance + Ending Balance) /2 Shares issued = Capeal Stock Value / Par Yalue of Common Stock Market Price per Common Share - (Net income Before interest Expence And income Tax Expense X 4y' Number or Shares or Common Stock Issued At the End of The Period A A Byte of Accounting Balance sheet As of December 31, 2020 Astets Current Assots Long-Term Assets Office Eavipment Accum, Depr - Office Equipment Net Oflice Equipment Computor Enuipment Accum, Depr, Computer Equipment Net Computer Equipment Total Long. Term Assets Total Assets \begin{tabular}{rr} & 79,10000 \\ $369,850,00 \\ \hline \end{tabular} Liabilities Current Liabilities Stockhoider's Equity. A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2021 A Byte of Accounting A Byte of Accounting A Byte of Accounting Statement of Cash Flows - Indirect Mothod For Year Ending December 31, 2021 Cash Flow from Operating Activities Net Income $26,661.52 Adjustments to reconcile net income to net cash flows from operating activities: Cash Flows from Investing Activities Purchase of equipment $(480.00) Net cash flows from investing activities (480.00) Cash Flows from Financing Activities Issuance of common stock $62,100.00 Proceeds from issuance of bonds payable 170.712.16 Payment of cash dividends Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period \begin{tabular}{|rr|} \hline & 231,172.16 \\ \hline$ & 243,617.40 \\ & 258,050.00 \\ \hline$ & 501,667.40 \\ \hline \hline \end{tabular} Noncash Activities Purchased equipment by issuing note payable $4,320.00 A Byte of Accounting Ratios For Year Ending December 31, 2021 Note: The estimated markat value of the business is four times Net Income Before interest Expense and Income Taxes Required Complefe the ratios and the open enowd questions and then upload your fle to Cyber Toxtcom for grading. Rourd to two decimal places = Rlandrumber 2 ) Daga' syes in invertory. Gross Margn Ratio Dividend Yiold fimes Irterest Earned = = - Book Value por Commion Shave Currart Furio Bshic Eartings per Share Total Assext Turnover Cash Flow on Fotal Assets Sreft Margin Ritio = = 4 Hocans Recervable Turmover Rasio = a 4 Pays' Sales Uncoliected = Days' Saies Unooliected Proft Morgin Ratio Dobk-ta- Equty Rafio Bwbe Ratio Acidhtest Ratio Use complete sertences lo complete tho fiti in querstions. Interpret and explain this company's Bock Value per Common Sharo Intripret and miplain this company's Debt Rntio Irterpret arid explain this company's Price- Earninas Ratio thterpect and axplain sis compary/s Gross Marain Rutio Interpret and explain this compary/s Gross Margin Ratio Explain wty you would or would not invest in this compary Edra-Spoce Ervilige Producions 50 Sheet Legal Pad Building Blocks of Accounting .. Financial Ratios Page 1 \begin{tabular}{|llllr|} \hline Veraien & First & Last & File & Date \\ \hline 1610 & Jermaine & Forbes & FJS944 & 11/40.22 \\ \hline \end{tabular} All sheets have been locked to protect the "HELP" messages built into this case. Enter the required data into the yellow filled cells on the Rabo sheet. \begin{tabular}{|l|l|} \hline Step 1 & Using the information from: \\ \hline & Post Closing TB (Trial Balance) Last Year \\ \hline Income Statement \\ \hline & Stockholders Equity \\ \hline & Balance Sheet \\ \hline & Cash Flow Statement \\ \hline Glossary Sheet \\ \hline & calculate the financial ratios and answer the open ended questions that are on the Ratio sheet \\ \hline \end{tabular} Step2 Upload the Flle. Jermaine, when you are ready to have your work graded you will upload your file FJ5944 XIS, FJ5944. xlsx or FJ5944.xisb from the botlom of the the same screen that the project was downloaded from. If you have a problem uploading see FAQ01. Ratio 201118 Building Blocks of Accounting w Financial Accounting Ratio Analysis Project In this project you wil calculate 18 financial ratios that help stakeholders determine if a company is a good investment. You will be asked to amwer lour questions related to interpreting and explaining the ratios. You mut complete the raties and the written answers to receive full marks en the project. Keep in mind that there is a Glossary Tab - here you wal find the ratio name and eamponerts Your project will have the following Company inlormation: 1. Balance Sheet, 2020 2. Incore Statement, 2021 3. Statement of 'Stockhalder' Cquity, 2021 4. Balance Sheet, 2021 5. Statemert of Cash Flows, 2021 You will have to complete the "Ratio" sheet Column E - Requies you to select (ffill h or Ink tol the proper numbers from the approcrate financial Szatement Column G - Requeres you to cakulate the rewhing ratio based on the comsonent you sekcted, rounded to two places Example: Par Value of Stock equak 50.01 Reminders about Calculations Average = ( Beginning Elalance + Ending Balance) /2 Shares issued = Capeal Stock Value / Par Yalue of Common Stock Market Price per Common Share - (Net income Before interest Expence And income Tax Expense X 4y' Number or Shares or Common Stock Issued At the End of The Period A A Byte of Accounting Balance sheet As of December 31, 2020 Astets Current Assots Long-Term Assets Office Eavipment Accum, Depr - Office Equipment Net Oflice Equipment Computor Enuipment Accum, Depr, Computer Equipment Net Computer Equipment Total Long. Term Assets Total Assets \begin{tabular}{rr} & 79,10000 \\ $369,850,00 \\ \hline \end{tabular} Liabilities Current Liabilities Stockhoider's Equity. A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2021 A Byte of Accounting A Byte of Accounting A Byte of Accounting Statement of Cash Flows - Indirect Mothod For Year Ending December 31, 2021 Cash Flow from Operating Activities Net Income $26,661.52 Adjustments to reconcile net income to net cash flows from operating activities: Cash Flows from Investing Activities Purchase of equipment $(480.00) Net cash flows from investing activities (480.00) Cash Flows from Financing Activities Issuance of common stock $62,100.00 Proceeds from issuance of bonds payable 170.712.16 Payment of cash dividends Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period \begin{tabular}{|rr|} \hline & 231,172.16 \\ \hline$ & 243,617.40 \\ & 258,050.00 \\ \hline$ & 501,667.40 \\ \hline \hline \end{tabular} Noncash Activities Purchased equipment by issuing note payable $4,320.00 A Byte of Accounting Ratios For Year Ending December 31, 2021 Note: The estimated markat value of the business is four times Net Income Before interest Expense and Income Taxes Required Complefe the ratios and the open enowd questions and then upload your fle to Cyber Toxtcom for grading. Rourd to two decimal places = Rlandrumber 2 ) Daga' syes in invertory. Gross Margn Ratio Dividend Yiold fimes Irterest Earned = = - Book Value por Commion Shave Currart Furio Bshic Eartings per Share Total Assext Turnover Cash Flow on Fotal Assets Sreft Margin Ritio = = 4 Hocans Recervable Turmover Rasio = a 4 Pays' Sales Uncoliected = Days' Saies Unooliected Proft Morgin Ratio Dobk-ta- Equty Rafio Bwbe Ratio Acidhtest Ratio Use complete sertences lo complete tho fiti in querstions. Interpret and explain this company's Bock Value per Common Sharo Intripret and miplain this company's Debt Rntio Irterpret arid explain this company's Price- Earninas Ratio thterpect and axplain sis compary/s Gross Marain Rutio Interpret and explain this compary/s Gross Margin Ratio Explain wty you would or would not invest in this compary Edra-Spoce