Changes in the company's balance sheet accounts over the year are summarized as follows: Accounts receivable decreased by $85,000. Accrued Interest Receivable increased by $15,000. Inventory decreased by $280,000. Accounts payable related to suppliers of merchandise decreased by $240,000. Short-term prepayments of operating expenses decreased by $18,000. Accrued liabilities for operating expenses increased by $35,000. Liability for accrued interest payable decreased by $16,000. Liability for accrued income taxes payable increased by $25,000. 9. As an investment, $120,000 of marketable securities were purchased during the year. Marketable securities with a book value of $210,000 were sold. $250,000 was invested as a loan to another company. $190,000 of loan given before were collected. $3,800,000 of plant assets were purchased for cash. Plant assets with a book value of $360,000 were sold during the year. $740,000 were borrowed as notes payable (long term). $620,000 of notes payable (long term) were paid during the year. Bonds payable issued during the year was $1,100,000. $890,000 of capital stock was issued during the year. Retained earnings at the beginning of the year was $1,500,000 and at the end of year was $1,810,000. Dividend was declared and paid in cash during the year. Cash balance at the beginning of the year was $448,000 and at the end of the year was $330,000. All investing and financing activities were cash transactions. Prepare a complete statement of cash flows for Bengal Products Inc. for the year 2020 using the direct method and show the reconcillation of cash flow from operating activities using the indirect method.
Changes in the company's balance sheet accounts over the year are summarized as follows: Accounts receivable decreased by $85,000. Accrued Interest Receivable increased by $15,000. Inventory decreased by $280,000. Accounts payable related to suppliers of merchandise decreased by $240,000. Short-term prepayments of operating expenses decreased by $18,000. Accrued liabilities for operating expenses increased by $35,000. Liability for accrued interest payable decreased by $16,000. Liability for accrued income taxes payable increased by $25,000. 9. As an investment, $120,000 of marketable securities were purchased during the year. Marketable securities with a book value of $210,000 were sold. $250,000 was invested as a loan to another company. $190,000 of loan given before were collected. $3,800,000 of plant assets were purchased for cash. Plant assets with a book value of $360,000 were sold during the year. $740,000 were borrowed as notes payable (long term). $620,000 of notes payable (long term) were paid during the year. Bonds payable issued during the year was $1,100,000. $890,000 of capital stock was issued during the year. Retained earnings at the beginning of the year was $1,500,000 and at the end of year was $1,810,000. Dividend was declared and paid in cash during the year. Cash balance at the beginning of the year was $448,000 and at the end of the year was $330,000. All investing and financing activities were cash transactions. Prepare a complete statement of cash flows for Bengal Products Inc. for the year 2020 using the direct method and show the reconcillation of cash flow from operating activities using the indirect method.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Changes in the company's
- Accounts receivable decreased by $85,000.
- Accrued Interest Receivable increased by $15,000.
- Inventory decreased by $280,000.
- Accounts payable related to suppliers of merchandise decreased by $240,000.
- Short-term prepayments of operating expenses decreased by $18,000.
- Accrued liabilities for operating expenses increased by $35,000.
- Liability for accrued interest payable decreased by $16,000.
- Liability for accrued income taxes payable increased by $25,000.
9. As an investment, $120,000 of marketable securities were purchased during the year. - Marketable securities with a book value of $210,000 were sold.
- $250,000 was invested as a loan to another company.
- $190,000 of loan given before were collected.
- $3,800,000 of plant assets were purchased for cash.
- Plant assets with a book value of $360,000 were sold during the year.
- $740,000 were borrowed as notes payable (long term).
- $620,000 of notes payable (long term) were paid during the year.
- Bonds payable issued during the year was $1,100,000.
- $890,000 of capital stock was issued during the year.
Retained earnings at the beginning of the year was $1,500,000 and at the end of year was $1,810,000.- Dividend was declared and paid in cash during the year.
- Cash balance at the beginning of the year was $448,000 and at the end of the year was $330,000.
- All investing and financing activities were cash transactions.
Prepare a complete statement of cash flows for Bengal Products Inc. for the year 2020 using the direct method and show the reconcillation of cash flow from operating activities using the indirect method.
Transcribed Image Text:ACT 201 Section 5 Final Assignment Spring 2021 - Excel
Arup Saha
AS
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Tell me what you want to do
& Share
X Cut
E AutoSum
Cambria
A A
22 Wrap Text
会了
11
General
e Copy
V Fill
Sort & Find &
Filter - Select
Paste
BIU V
A v
$ • %
Conditional Format as
Cell
Insert Delete Format
.00
E Merge & Center
00
V Format Painter
Formatting
Table
Styles
O Clear
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
117
fx
В
D
E
G
H
J
L
M
8
9.
Bengal Products Inc.
10
Income Statement
11
For the year ended December 31, 2020
12
13
Revenue:
Net Sales
$
9,500,000
$
14
15
Interest Income
320,000
16
Gain on Sales of Marketable Securities
$
70,000
17
Total revenue and gains
$ 9,890,000
18
19
Costs and expenses:
$ 4,860,000
Cost of goods sold
Operating expenses
(Including depreciation of 700,000)
Interest expense
20
$ 3,740,000
$ 270,000
$ 300,000
$
21
22
23
Income tax expenses
24
Loss on sales of plant assets
90,000
25
Total costs, expenses and losses
$ 9,260,000
26
27
Net Income
$
630,000
Depreciation Problem
Cash Flow Problem
+)
140%
6:31 PM
O Type here to search
ab
35°C Haze
5/21/2021
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education