Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the answers to these questions. Heres the balance sheet and financial statement to help fill it out. please help im struggling Balance in
I need the answers to these questions. Heres the balance sheet and financial statement to help fill it out. please help im struggling Balance in Notes Payable @ 12/31/ Yr4 Make another Loan Repayment on 1/1/Yrr5 (same as Yr. 3 \& 4) Balance in Notes Payable @ 12/31/Yr5 33 Interest Expense for Year 5(12/31/ yr 5 balance x8%) Equipment Account Balance (12/31/ YrA Accumulated Depreciation Balance @ 12/31/ Yr4 Book Value of Equipment @12/31/Yr4 Sale of Equipment for $6,500 on 1/1/YrS Amount of Gain or (Loss) on Sale of Equipment Debt to Assets Ratio (Totol Liabilities / Total Assets) for Year 4? Equity to Assets Ratio (Totol SE / Total Assets) for Year 4? 4. Submit the project by Sunday, October 1 - Type your responses into this document - Save it with your name on it, and submit it through Blackboard ACCT 2003 Big Picture Project 2023 Proforma Statements for Bert's Bikes \begin{tabular}{|c|c|c|c|c|} \hline & Statement of & Stockhoders Equity & & \\ \hline Beginning Common Stock & 0 & 31,000 & 31,000 & 31,000 \\ \hline Plus: Common Stock issued & 31,000 & 0 & 0 & 0 \\ \hline Ending Common Stock & 31,000 & 31,000 & 31,000 & 31,000 \\ \hline Beginning hetained Earnings & 0 & 4,400 & 9,350 & 18,450 \\ \hline+ Net income & 4,400 & 6,500 & 12,200 & 12,920 \\ \hline - Dividends & 0 & 1,550 & 3,100 & 3,100 \\ \hline Ending fietained Earnings & 4,400 & 9,350 & 18,450 & 28,270 \\ \hline Total Stockholders Equity & 35,400 & 40,350 & 49,450 & 59,270 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Balance sheet } \\ \hline Assets & & & & \\ \hline Cash & 48,400 & 53,950 & 57,350 & 62,170 \\ \hline Inventory & 5,000 & 7,400 & 10,700 & 27,300 \\ \hline Equipment & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline Accumulated Depreciation & (3,000) & (6,000) & (9,000) & (12,000) \\ \hline Total Assets & 65,400 & 70,350 & +2 & 92,470 \\ \hline \multicolumn{5}{|l|}{7ordinsetsDablities} \\ \hline Notes Payable & 30,000 & 30,000 & 25,000 & 21,000 \\ \hline Total Labilicies & 30,000 & 30,000 & 25,000 & 21,000 \\ \hline \multicolumn{5}{|l|}{TotalLabulituesSteckholdersfequity} \\ \hline Common Stock & 31,000 & 31,000 & 31,000 & 31,000 \\ \hline Retained Earnings & 4,400 & 9,350 & 18,450 & 28,270 \\ \hline Total Stockholders Equity & 35,400 & 40,350 & 49,450 & 59,270 \\ \hline Totol Liabulities \& SE & 65,400 & 70,350 & 74,450 & 80,270 \\ \hline \multicolumn{5}{|c|}{ Statement of casph flows } \\ \hline Net Cashflow from Operating & 2,400 & 7,100 & 11,900 & 11,920 \\ \hline Net Cashflow from Investing & (15,000) & 0 & 0 & 0 \\ \hline Net Cashlow from Financing & 61,000 & (1,550) & (8,100) & (7,100) \\ \hline Net Change in Cash & 48,400 & 5,550 & 3,800 & 4,620 \\ \hline Beginning Cash Balsnce & 0 & 48,400 & 53,950 & 57,750 \\ \hline Ending Cash Balance & 48,400 & 53,950 & 57,750 & 62,570 \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} A. B ACCT 2003 Big Picture Project Horizontal Transaction Analysis 2023 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{4}{*}{YearlTrantmentEvives} & \multicolumn{8}{|c|}{ Balance Sheet } & \multicolumn{2}{|c|}{ Income Statement } \\ \hline & \multicolumn{5}{|c|}{ Assets } & \multirow{2}{*}{\begin{tabular}{|c|} Labilities \\ Notes Papabie \\ \end{tabular}} & \multicolumn{2}{|c|}{ Stockholders Equity } & \multirow[t]{2}{*}{ Revenue } & \multirow[t]{2}{*}{ - Expense } \\ \hline & & Cash & Inventory & Equipment & AecumulatedDepredabien & & Common Stock & BetainedEamines & & \\ \hline & & 0 & 0 & e & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 11 & FA & 30,000 & & & & 30,000 & & & & \\ \hline 21 & FA & 31,000 & & & & & 31,000 & & & \\ \hline 12 & in & (15,000) & & 15,000 & & & & & & \\ \hline 13 & DA & (16,000) & 16,000 & & & & & & & \\ \hline 14 & OA & 20.000 & & & & & & 20,000 & 20,000 & \\ \hline 14 & OA. & 22,000 & & & & & & 22,000 & 22.000 & \\ \hline 14 & & & (11,000) & & & & & (11,000) & & 11,000 \\ \hline 15 & OA & {[21,200)} & & & & & & (21,200) & & 21,200 \\ \hline 25 & & & & & (3,0) & & & {[3,000)} & & 3,000 \\ \hline 15 & OA & (2,400) & & & & & & (2,400) & & 2,400 \\ \hline Cown: & & & & & & & & & (42,000) & (37,600) \\ \hline \multirow[t]{2}{*}{ fatal } & & 48.400 & 5,000 & 15,000 & x(3,000) & 30,000 & 31,000 & 4,400 & 0 & 0 \\ \hline & & & 55,400 & & \multicolumn{2}{|c|}{ fote Lisbroes is if * } & 65,400 & & \\ \hline Reiwime & & 46,400 & 5,000 & 15,000 & {[3,000)} & 30,000 & 31,000 & 4,400 & 0 & 0 \\ \hline 21 & OA & {[15,000)} & 15,000 & & & & & & & \\ \hline 23 & OA & 22,300 & & & & & & 22,300 & 22,300 & \\ \hline 2.2 & QA & 25,200 & & & & & & 25,200 & 25,200 & \\ \hline 22 & & & {[12,600)} & & & & & {[12,600]} & & 12,600 \\ \hline 2.3 & OA & (23,000) & & & & & & (23,000) & & 23,000 \\ \hline 23 & & & & & {[3,000]} & & & (3,000) & & 3,009 \\ \hline 23 & OA & (2,400) & & & & & + & {[2,400]} & & 2,400 \\ \hline 24 & FA & (1,550) & & & & & & {[1,550)} & & \\ \hline Oesce: & & & & & & & & & [47,500)] & {[41,000)} \\ \hline 7etal & & 53,950 & 7,400 & 15,000 & (6,000) & 30,000 & 31,000 & 9,350 & 0 & 0 \\ \hline & & Totor Aas & rtan= & 70,350 & & Tengitiabulities L & SSF1= & 70,350 & & \\ \hline \end{tabular} ACCT 2003 Bic Picture Project Horixontal Transaction Analysis 2023 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{FearlTrans} & \multicolumn{8}{|c|}{ Balance Sheet } & \multicolumn{2}{|c|}{ Income statement } \\ \hline & \multicolumn{5}{|c|}{ Assets } & \multirow{2}{*}{\begin{tabular}{|c|} I Labilieies \\ Motei Pryabla \\ \end{tabular}} & \multicolumn{2}{|c|}{ Stockholders fquity } & \multirow[t]{2}{*}{ Revenue } & \multirow[t]{2}{*}{ - Expense } \\ \hline & Canfow & Conh & infentsor & Equipment & AccumulatedDeprecation & & Common Stock & RetainedEarnings & & \\ \hline & & 53,950 & 7,400 & 15,000 & (6,000) & 30,000 & 31,000 & 9,350 & 0 & o \\ \hline 21 & OA & (28,000) & 18.000 & & & & & & & \\ \hline & QA & 27,700 & & & & & & 27,700 & 27,700 & \\ \hline H-2 & OA & 29,600 & & & & & & 29,400 & 29,400 & \\ \hline 32 & & & {[14,700]} & & & & & (14,700) & & 14,700 \\ \hline 3-3 & FA & (5,000) & & & & (5,000) & & & & \\ \hline 34 & OA & (25,200) & & & & & & (25,200) & & 25,200 \\ \hline 1-4 & & & & & {[3,000]} & & & {[3,000]} & & 3,000 \\ \hline 3 & OA & {2,400} & & & & & & (2,000) & & 2000 \\ \hline 3 & FA: & (2,100) & & & & & & (3,100) & + & \\ \hline Cousing & & & & & & & & & (57,100) & (44,900) \\ \hline \multirow[t]{2}{*}{ Row } & & 57,350 & 10,700 & 15,000 & (9,000) & 25,000 & 31,000 & 18,450 & 0 & \\ \hline & & \multicolumn{2}{|c|}{ Tocat Aniets a } & 74,050 & & \multicolumn{2}{|c|}{ Teter bistolitien is SC * } & 74,450 & & \\ \hline & & 57,350 & 10,700 & 15,000 & (9.000) & 25,000 & 31000 & 18,450 & 0 & 0 \\ \hline 41 & QA & (21,000) & {[21,000]} & & & & & & & \\ \hline 42 & OA & 29,300 & & & & & & 29,300 & 29,300 & \\ \hline 42 & OA & 34,000 & & & & & & 34,000 & 34,000 & \\ \hline 47 & & & {17,) & & & & & (17,000) & & 17,000 \\ \hline 4-3 & fA & (4.000) & & & & (4,000) & & & & \\ \hline 4-4: & OA & (26,700) & & & & & & (28,700) & & 28,700 \\ \hline 44 & & & & & (3.000) & & & (3,000) & & 3,000 \\ \hline 6-4 & OA & {[1,689]} & & & & & & (1,680) & & 1,650 \\ \hline 4.5. & IA & (3,100) & & & & & & (3,100) & & \\ \hline Genin: & & & & & & & & & (63,300) & {[50,380)} \\ \hline fete & & 62,110 & {[27,300]} & 15,000 & {[12,000)} & 21,000 & 31,000 & 28,270 & 0 & 0 \\ \hline & & Fotor dise & & 37,870 & & & & 80.270 & & \\ \hline \end{tabular} Balance in Notes Payable @ 12/31/ Yr4 Make another Loan Repayment on 1/1/Yrr5 (same as Yr. 3 \& 4) Balance in Notes Payable @ 12/31/Yr5 33 Interest Expense for Year 5(12/31/ yr 5 balance x8%) Equipment Account Balance (12/31/ YrA Accumulated Depreciation Balance @ 12/31/ Yr4 Book Value of Equipment @12/31/Yr4 Sale of Equipment for $6,500 on 1/1/YrS Amount of Gain or (Loss) on Sale of Equipment Debt to Assets Ratio (Totol Liabilities / Total Assets) for Year 4? Equity to Assets Ratio (Totol SE / Total Assets) for Year 4? 4. Submit the project by Sunday, October 1 - Type your responses into this document - Save it with your name on it, and submit it through Blackboard ACCT 2003 Big Picture Project 2023 Proforma Statements for Bert's Bikes \begin{tabular}{|c|c|c|c|c|} \hline & Statement of & Stockhoders Equity & & \\ \hline Beginning Common Stock & 0 & 31,000 & 31,000 & 31,000 \\ \hline Plus: Common Stock issued & 31,000 & 0 & 0 & 0 \\ \hline Ending Common Stock & 31,000 & 31,000 & 31,000 & 31,000 \\ \hline Beginning hetained Earnings & 0 & 4,400 & 9,350 & 18,450 \\ \hline+ Net income & 4,400 & 6,500 & 12,200 & 12,920 \\ \hline - Dividends & 0 & 1,550 & 3,100 & 3,100 \\ \hline Ending fietained Earnings & 4,400 & 9,350 & 18,450 & 28,270 \\ \hline Total Stockholders Equity & 35,400 & 40,350 & 49,450 & 59,270 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Balance sheet } \\ \hline Assets & & & & \\ \hline Cash & 48,400 & 53,950 & 57,350 & 62,170 \\ \hline Inventory & 5,000 & 7,400 & 10,700 & 27,300 \\ \hline Equipment & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline Accumulated Depreciation & (3,000) & (6,000) & (9,000) & (12,000) \\ \hline Total Assets & 65,400 & 70,350 & +2 & 92,470 \\ \hline \multicolumn{5}{|l|}{7ordinsetsDablities} \\ \hline Notes Payable & 30,000 & 30,000 & 25,000 & 21,000 \\ \hline Total Labilicies & 30,000 & 30,000 & 25,000 & 21,000 \\ \hline \multicolumn{5}{|l|}{TotalLabulituesSteckholdersfequity} \\ \hline Common Stock & 31,000 & 31,000 & 31,000 & 31,000 \\ \hline Retained Earnings & 4,400 & 9,350 & 18,450 & 28,270 \\ \hline Total Stockholders Equity & 35,400 & 40,350 & 49,450 & 59,270 \\ \hline Totol Liabulities \& SE & 65,400 & 70,350 & 74,450 & 80,270 \\ \hline \multicolumn{5}{|c|}{ Statement of casph flows } \\ \hline Net Cashflow from Operating & 2,400 & 7,100 & 11,900 & 11,920 \\ \hline Net Cashflow from Investing & (15,000) & 0 & 0 & 0 \\ \hline Net Cashlow from Financing & 61,000 & (1,550) & (8,100) & (7,100) \\ \hline Net Change in Cash & 48,400 & 5,550 & 3,800 & 4,620 \\ \hline Beginning Cash Balsnce & 0 & 48,400 & 53,950 & 57,750 \\ \hline Ending Cash Balance & 48,400 & 53,950 & 57,750 & 62,570 \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} A. B ACCT 2003 Big Picture Project Horizontal Transaction Analysis 2023 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{4}{*}{YearlTrantmentEvives} & \multicolumn{8}{|c|}{ Balance Sheet } & \multicolumn{2}{|c|}{ Income Statement } \\ \hline & \multicolumn{5}{|c|}{ Assets } & \multirow{2}{*}{\begin{tabular}{|c|} Labilities \\ Notes Papabie \\ \end{tabular}} & \multicolumn{2}{|c|}{ Stockholders Equity } & \multirow[t]{2}{*}{ Revenue } & \multirow[t]{2}{*}{ - Expense } \\ \hline & & Cash & Inventory & Equipment & AecumulatedDepredabien & & Common Stock & BetainedEamines & & \\ \hline & & 0 & 0 & e & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 11 & FA & 30,000 & & & & 30,000 & & & & \\ \hline 21 & FA & 31,000 & & & & & 31,000 & & & \\ \hline 12 & in & (15,000) & & 15,000 & & & & & & \\ \hline 13 & DA & (16,000) & 16,000 & & & & & & & \\ \hline 14 & OA & 20.000 & & & & & & 20,000 & 20,000 & \\ \hline 14 & OA. & 22,000 & & & & & & 22,000 & 22.000 & \\ \hline 14 & & & (11,000) & & & & & (11,000) & & 11,000 \\ \hline 15 & OA & {[21,200)} & & & & & & (21,200) & & 21,200 \\ \hline 25 & & & & & (3,0) & & & {[3,000)} & & 3,000 \\ \hline 15 & OA & (2,400) & & & & & & (2,400) & & 2,400 \\ \hline Cown: & & & & & & & & & (42,000) & (37,600) \\ \hline \multirow[t]{2}{*}{ fatal } & & 48.400 & 5,000 & 15,000 & x(3,000) & 30,000 & 31,000 & 4,400 & 0 & 0 \\ \hline & & & 55,400 & & \multicolumn{2}{|c|}{ fote Lisbroes is if * } & 65,400 & & \\ \hline Reiwime & & 46,400 & 5,000 & 15,000 & {[3,000)} & 30,000 & 31,000 & 4,400 & 0 & 0 \\ \hline 21 & OA & {[15,000)} & 15,000 & & & & & & & \\ \hline 23 & OA & 22,300 & & & & & & 22,300 & 22,300 & \\ \hline 2.2 & QA & 25,200 & & & & & & 25,200 & 25,200 & \\ \hline 22 & & & {[12,600)} & & & & & {[12,600]} & & 12,600 \\ \hline 2.3 & OA & (23,000) & & & & & & (23,000) & & 23,000 \\ \hline 23 & & & & & {[3,000]} & & & (3,000) & & 3,009 \\ \hline 23 & OA & (2,400) & & & & & + & {[2,400]} & & 2,400 \\ \hline 24 & FA & (1,550) & & & & & & {[1,550)} & & \\ \hline Oesce: & & & & & & & & & [47,500)] & {[41,000)} \\ \hline 7etal & & 53,950 & 7,400 & 15,000 & (6,000) & 30,000 & 31,000 & 9,350 & 0 & 0 \\ \hline & & Totor Aas & rtan= & 70,350 & & Tengitiabulities L & SSF1= & 70,350 & & \\ \hline \end{tabular} ACCT 2003 Bic Picture Project Horixontal Transaction Analysis 2023 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{FearlTrans} & \multicolumn{8}{|c|}{ Balance Sheet } & \multicolumn{2}{|c|}{ Income statement } \\ \hline & \multicolumn{5}{|c|}{ Assets } & \multirow{2}{*}{\begin{tabular}{|c|} I Labilieies \\ Motei Pryabla \\ \end{tabular}} & \multicolumn{2}{|c|}{ Stockholders fquity } & \multirow[t]{2}{*}{ Revenue } & \multirow[t]{2}{*}{ - Expense } \\ \hline & Canfow & Conh & infentsor & Equipment & AccumulatedDeprecation & & Common Stock & RetainedEarnings & & \\ \hline & & 53,950 & 7,400 & 15,000 & (6,000) & 30,000 & 31,000 & 9,350 & 0 & o \\ \hline 21 & OA & (28,000) & 18.000 & & & & & & & \\ \hline & QA & 27,700 & & & & & & 27,700 & 27,700 & \\ \hline H-2 & OA & 29,600 & & & & & & 29,400 & 29,400 & \\ \hline 32 & & & {[14,700]} & & & & & (14,700) & & 14,700 \\ \hline 3-3 & FA & (5,000) & & & & (5,000) & & & & \\ \hline 34 & OA & (25,200) & & & & & & (25,200) & & 25,200 \\ \hline 1-4 & & & & & {[3,000]} & & & {[3,000]} & & 3,000 \\ \hline 3 & OA & {2,400} & & & & & & (2,000) & & 2000 \\ \hline 3 & FA: & (2,100) & & & & & & (3,100) & + & \\ \hline Cousing & & & & & & & & & (57,100) & (44,900) \\ \hline \multirow[t]{2}{*}{ Row } & & 57,350 & 10,700 & 15,000 & (9,000) & 25,000 & 31,000 & 18,450 & 0 & \\ \hline & & \multicolumn{2}{|c|}{ Tocat Aniets a } & 74,050 & & \multicolumn{2}{|c|}{ Teter bistolitien is SC * } & 74,450 & & \\ \hline & & 57,350 & 10,700 & 15,000 & (9.000) & 25,000 & 31000 & 18,450 & 0 & 0 \\ \hline 41 & QA & (21,000) & {[21,000]} & & & & & & & \\ \hline 42 & OA & 29,300 & & & & & & 29,300 & 29,300 & \\ \hline 42 & OA & 34,000 & & & & & & 34,000 & 34,000 & \\ \hline 47 & & & {17,) & & & & & (17,000) & & 17,000 \\ \hline 4-3 & fA & (4.000) & & & & (4,000) & & & & \\ \hline 4-4: & OA & (26,700) & & & & & & (28,700) & & 28,700 \\ \hline 44 & & & & & (3.000) & & & (3,000) & & 3,000 \\ \hline 6-4 & OA & {[1,689]} & & & & & & (1,680) & & 1,650 \\ \hline 4.5. & IA & (3,100) & & & & & & (3,100) & & \\ \hline Genin: & & & & & & & & & (63,300) & {[50,380)} \\ \hline fete & & 62,110 & {[27,300]} & 15,000 & {[12,000)} & 21,000 & 31,000 & 28,270 & 0 & 0 \\ \hline & & Fotor dise & & 37,870 & & & & 80.270 & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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