Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Projected Balance Sheet Figures in Thousand Taka Sales 17,953.00 Ratio Dec-20 Column1 Column2 Column3 Cash 4.18% 749.99 Accounts receivable 13.33% 2,393.73 Inventory 25% 4,488.25 Prepaid

image text in transcribed
image text in transcribed
image text in transcribed
Projected Balance Sheet Figures in Thousand Taka Sales 17,953.00 Ratio Dec-20 Column1 Column2 Column3 Cash 4.18% 749.99 Accounts receivable 13.33% 2,393.73 Inventory 25% 4,488.25 Prepaid Expenses 1% 179.53 Current Assets 7,811.50 Net Plant and Equipment Pre-publication expenses Other assets Total Assets 12.92% 2.92% 2,714.00 2,318.72 524.99 13,369.21 9.20% Accounts Payable Current Portion of LT Debt Current Liabilities 1,651.98 178 1,829.98 5% Bonds 5 1/2 % Bonds 1,556.00 1,394.00 Term Debt 2,950.00 Common Stock Retained earnings 1,873.00 3,228.89 5,101.89 9,881.87 45% 9% Total Equity Total Liabilities and Equity Summary Income Statement Gross Profit Cash Operating costs Depreciation Profit Before Taxes Taxes = 40% Net Income Dividend 40% of net income Retained Earnings 8,078.85 1,615.77 2,500.00 3,963.08 1,585.23 2,377.85 951.14 1,426.71 12. Use the Excel sheet. (Link Given) (a) Fill out the box for a. Cash sales in March. b. Cash collection boxes for the month of May. C. Scheduled labour and merchandise expenses box for the month of April. Projected Balance Sheet Figures in Thousand Taka Sales 17,953.00 Ratio Dec-20 Column1 Column2 Column3 Cash 4.18% 749.99 Accounts receivable 13.33% 2,393.73 Inventory 25% 4,488.25 Prepaid Expenses 1% 179.53 Current Assets 7,811.50 Net Plant and Equipment Pre-publication expenses Other assets Total Assets 12.92% 2.92% 2,714.00 2,318.72 524.99 13,369.21 9.20% Accounts Payable Current Portion of LT Debt Current Liabilities 1,651.98 178 1,829.98 5% Bonds 5 1/2 % Bonds 1,556.00 1,394.00 Term Debt 2,950.00 Common Stock Retained earnings 1,873.00 3,228.89 5,101.89 9,881.87 45% 9% Total Equity Total Liabilities and Equity Summary Income Statement Gross Profit Cash Operating costs Depreciation Profit Before Taxes Taxes = 40% Net Income Dividend 40% of net income Retained Earnings 8,078.85 1,615.77 2,500.00 3,963.08 1,585.23 2,377.85 951.14 1,426.71 12. Use the Excel sheet. (Link Given) (a) Fill out the box for a. Cash sales in March. b. Cash collection boxes for the month of May. C. Scheduled labour and merchandise expenses box for the month of April

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

Sound Investing Uncover Fraud And Protect Your Portfolio

Authors: Kate Mooney

1st Edition

0071481826, 9780071481823

More Books

Students also viewed these Accounting questions

Question

=+What do you think about the CDFI Fund, establish in 1994?

Answered: 1 week ago