This is the continued question for my 1st post

This is the dropbox 1

Hope this is clear and i have also attached the question sheet

This work continues on your work from Dropbox 1. TASK 1 USE D81 to prepare a statement of income and statement of financial position for the company at the end of the DB1 period TASK 2 Add transactions A to I to your journal entries and T-accounts from DB1. You have 5 tasks to complete. Purchase transaction Model A Ascend Pro 3 Quantity 10,650 Price paid each Current status $20,100 Outstanding Sales transactions Model B Ascend Pro 3 How are Price sold each customers paying $40 400 Cash Number of units NOT pald for at present Quantity 12 Current status Paid in full C Ascend Pro 2 7 US$20,769 On credit 5 Outstanding D Ascend Pro 3 5,319 US$36 360 On credit 1773 Outstanding E Service Revenue US$263,310 On credit Outstanding Expense transaction F Telecom expenses US$9,250 On credit, still outstanding G Marketing Staff total hired 3 average pay of Paid in full S 19,145 H Rent US$21,198 On credit, still outstanding 1 Licenses US$29,809 On credit, still outstanding TASK 3 Including the new transactions, prepare a statement of income and statement of financial position for the company at the end of the DB2 period. TASK 5 For the end of the DB1 and 82 periods calculate: current ratio profit margin on sales ratio return of total assets ratio - return on equity ratio What can you say about the performance of this company? Comment on three areas of interest by interpreting the calculated figures, not just stating and comparing them. TASK 4 Prepare vertical and horizontal analysis of the income statement for the company C 52 Pw DEE 1 SR CM H w 314 52.440 LE Payale $11.14 215 Eye 522.50 Care C LEIGH SICE will BEN TII TS Twi 51 Ta Tal 4 Arre SWIN WW MAS New PS HIFFIN CE FRNS OTHE Ew 919. w Basta Hea HETS Ae Tele 13 Ta HCH CH Legal 5 PRE Date #1 Journal Entries Account Title Debit Credit Cash S2,998.899 Common Stock $2.998,899 1 #2 Purchase Cash $741.000 (260x52850) $741,000 #3 Purchase Cash $223.125 (17x153125) $223.125 (66x$5558) $366.828 #4 Accounts Receivable $366.828 Sales 45 $112.876 Cash Sales (4x528219) $112,876 #6 #7 Accounts Receivable Sales Accounts Receivable Sales Accounts Receivable Sales $129,805 |(5x$25961) $129.805 $339,625 (65x85225) $339,625 $593.142 (129x84598) 5593.142 S296,448 (5x524,704)-(4x$43.232 5296,448 #8 49 Salaries Expense Cash #10 Utilities Expense Cash $12.352 $12.352 #11 $14.411 Rent Expense Rent Payable $14,411 #12 59.264 Interest Expense Cash 59.264 #13 Advertisment Expense Advertisment Expense Payable $43,233 S43,233 #14 $15,749 Legal Expense Legal expense Payable $15,749 #15 $23.159 Equipment Bank Loan $23.159 Common stock $2.998.899 1 1 #S Cash Dr Cr $2.998.899 $741,000 12 $112.876 $223.125 13 $12,35210 End. Bal S2,998.899 End. Bal $2.135.298 Sales Purchase $741.000 S223,125 5366,828 $112.876 5 $129.805 76 S339.625 47 $$93.1428 3 End.Bal S964.125 Eod Bal $1.542.276 Salaries Expense $296.448 39 Accounts Receivables 54 $366,828 56 $129,805 57 $339,625 8 5593.142 End.Bal $1,429.400 Eud.Bal S296,448 #11 Rent Expense $14.411 $10 Utilities Expense $12.352 $12,152 End.Bal End. Bal $14,411 Interest Expense 59.264 Advertisment Expense $43,233 2) $12 13 End.Bal 59.264 End.Bal S43,233 Legal Expense $15,749 Equipment S23.159 N14 15 Eud.Bal $15,749 End.Bal S23.159 Bank Loan $23,159 415 Rent Payable $14.411 411 End.Bal $23.159 End. Bal $14.411 Interest Payable $9.264 #12 Advertisment Expense Payable $43.233 413 Eud.Bal $9.264 End.Bal $43.233 Legal Expense Payble $15.749 #14 S15,749 End. Bal Activate Windows Rolling Wheels sells bicycles from around the world online to Canadians. (Transaction N1) The Investors put purchase 2 different models of bicycles $2,998,899 in the company. The money was used to as follows: Model 2 Ascend Pro 1 3 Ascend Pro 2 Quantity 260 17 Price purchased each $2,850 $13,125 Over the course of the next year they had the following sales: How are customers paying Number of units not paid for at present Model Quantity Price sold each Current status 4 Ascend Pro 1 66 $5,558 On credit Paid entirely 5 Ascend Pro 2 4 $28,219 Cash Pald entirely 6 Ascend Pro 2 5 $25,961 On credit 2 Outstanding 7 Ascend Pro 1 65 $5225 On credit 32 Outstanding 8 Ascend Pro 1 129 $4,598 On credit 66 Outstanding (Transaction #9) 9 employees work for the company. They have been paid in full. Number of employees Pay/employee From these employees 5 averaged $24,704 and the other 4 averaged $43,232 over the period in question Over the course of the year they will spend the following: Payment 10 Utilities expense 11 Rent expense 12 Internet expense 13 Prom nal expense 14 Legal fees 15 Equipment Amount US$12,352 US$14,411 US$9,264 US$43 233 US$15,749 US$23,159 Payment Method Cash, nothing due On credit, still outstanding Cash, nothing due On credit, still outstanding On credit, still outstanding Received loan from bank This work continues on your work from Dropbox 1. TASK 1 USE D81 to prepare a statement of income and statement of financial position for the company at the end of the DB1 period TASK 2 Add transactions A to I to your journal entries and T-accounts from DB1. You have 5 tasks to complete. Purchase transaction Model A Ascend Pro 3 Quantity 10,650 Price paid each Current status $20,100 Outstanding Sales transactions Model B Ascend Pro 3 How are Price sold each customers paying $40 400 Cash Number of units NOT pald for at present Quantity 12 Current status Paid in full C Ascend Pro 2 7 US$20,769 On credit 5 Outstanding D Ascend Pro 3 5,319 US$36 360 On credit 1773 Outstanding E Service Revenue US$263,310 On credit Outstanding Expense transaction F Telecom expenses US$9,250 On credit, still outstanding G Marketing Staff total hired 3 average pay of Paid in full S 19,145 H Rent US$21,198 On credit, still outstanding 1 Licenses US$29,809 On credit, still outstanding TASK 3 Including the new transactions, prepare a statement of income and statement of financial position for the company at the end of the DB2 period. TASK 5 For the end of the DB1 and 82 periods calculate: current ratio profit margin on sales ratio return of total assets ratio - return on equity ratio What can you say about the performance of this company? Comment on three areas of interest by interpreting the calculated figures, not just stating and comparing them. TASK 4 Prepare vertical and horizontal analysis of the income statement for the company C 52 Pw DEE 1 SR CM H w 314 52.440 LE Payale $11.14 215 Eye 522.50 Care C LEIGH SICE will BEN TII TS Twi 51 Ta Tal 4 Arre SWIN WW MAS New PS HIFFIN CE FRNS OTHE Ew 919. w Basta Hea HETS Ae Tele 13 Ta HCH CH Legal 5 PRE Date #1 Journal Entries Account Title Debit Credit Cash S2,998.899 Common Stock $2.998,899 1 #2 Purchase Cash $741.000 (260x52850) $741,000 #3 Purchase Cash $223.125 (17x153125) $223.125 (66x$5558) $366.828 #4 Accounts Receivable $366.828 Sales 45 $112.876 Cash Sales (4x528219) $112,876 #6 #7 Accounts Receivable Sales Accounts Receivable Sales Accounts Receivable Sales $129,805 |(5x$25961) $129.805 $339,625 (65x85225) $339,625 $593.142 (129x84598) 5593.142 S296,448 (5x524,704)-(4x$43.232 5296,448 #8 49 Salaries Expense Cash #10 Utilities Expense Cash $12.352 $12.352 #11 $14.411 Rent Expense Rent Payable $14,411 #12 59.264 Interest Expense Cash 59.264 #13 Advertisment Expense Advertisment Expense Payable $43,233 S43,233 #14 $15,749 Legal Expense Legal expense Payable $15,749 #15 $23.159 Equipment Bank Loan $23.159 Common stock $2.998.899 1 1 #S Cash Dr Cr $2.998.899 $741,000 12 $112.876 $223.125 13 $12,35210 End. Bal S2,998.899 End. Bal $2.135.298 Sales Purchase $741.000 S223,125 5366,828 $112.876 5 $129.805 76 S339.625 47 $$93.1428 3 End.Bal S964.125 Eod Bal $1.542.276 Salaries Expense $296.448 39 Accounts Receivables 54 $366,828 56 $129,805 57 $339,625 8 5593.142 End.Bal $1,429.400 Eud.Bal S296,448 #11 Rent Expense $14.411 $10 Utilities Expense $12.352 $12,152 End.Bal End. Bal $14,411 Interest Expense 59.264 Advertisment Expense $43,233 2) $12 13 End.Bal 59.264 End.Bal S43,233 Legal Expense $15,749 Equipment S23.159 N14 15 Eud.Bal $15,749 End.Bal S23.159 Bank Loan $23,159 415 Rent Payable $14.411 411 End.Bal $23.159 End. Bal $14.411 Interest Payable $9.264 #12 Advertisment Expense Payable $43.233 413 Eud.Bal $9.264 End.Bal $43.233 Legal Expense Payble $15.749 #14 S15,749 End. Bal Activate Windows Rolling Wheels sells bicycles from around the world online to Canadians. (Transaction N1) The Investors put purchase 2 different models of bicycles $2,998,899 in the company. The money was used to as follows: Model 2 Ascend Pro 1 3 Ascend Pro 2 Quantity 260 17 Price purchased each $2,850 $13,125 Over the course of the next year they had the following sales: How are customers paying Number of units not paid for at present Model Quantity Price sold each Current status 4 Ascend Pro 1 66 $5,558 On credit Paid entirely 5 Ascend Pro 2 4 $28,219 Cash Pald entirely 6 Ascend Pro 2 5 $25,961 On credit 2 Outstanding 7 Ascend Pro 1 65 $5225 On credit 32 Outstanding 8 Ascend Pro 1 129 $4,598 On credit 66 Outstanding (Transaction #9) 9 employees work for the company. They have been paid in full. Number of employees Pay/employee From these employees 5 averaged $24,704 and the other 4 averaged $43,232 over the period in question Over the course of the year they will spend the following: Payment 10 Utilities expense 11 Rent expense 12 Internet expense 13 Prom nal expense 14 Legal fees 15 Equipment Amount US$12,352 US$14,411 US$9,264 US$43 233 US$15,749 US$23,159 Payment Method Cash, nothing due On credit, still outstanding Cash, nothing due On credit, still outstanding On credit, still outstanding Received loan from bank