Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Instructions 1 Review the Comparative Balance Sheet and the additional information provided for this company. 2 Using an excel formula, calculate the change in the
Instructions
Review the Comparative Balance Sheet and the additional information provided for this company.
Using an excel formula, calculate the change in the balances from
Add a column next to the change amount an indicate if this was an Increase or Decrease.
Add a column next to the IncreaseDecrease Column and indicate if this account has a normal DR or CR balance.
Add a column next to the DRCR column and indicate the section of the Cash Flow Statement where this item is presented Operating Investing, Financing
You need to complete the data below the Cash Flow Statement in order to get information needed. For example, you need to rollforward Retained Earnings in order to Net Income.
Prepare a statement of cash flows using the indirect method in the highlighted section below. Add lines if necessary.
Use Formulas for any and all amounts coming from another location in the file. Use formulas for any and all math calculations. DO NOT use a calculator and then enter the number.
Hurricane damage is unusual in that part of the country.
You will use types of formulas in this project:
LINK: This is a formula that LINK the data from one location to another. For example, the Change in AR on the Cash flow can be linked to the change in AR in step
MATH: Do NOT use a calculator and then type in number. Any where you would add, subtract, multiply or divide, do that using excel formulas. You may use paper and calculator to double check your work.
SUM: In cases where you are adding, you may either use a math formula, adding up the cells or you may use the Auto Sum feature. Again, do NOT enter amounts you are calculating. Use a formula.
Equipment that had cost $ and was depreciated at time of disposal was sold for $
$ of the longterm note payable was paid by issuing common stock.
Cash dividends paid were $
On January the building was completely destroyed by a hurricane. Insurance proceeds on the building were $net of $ taxes
Investments availableforsale were sold at $ below their cost. The company has made similar sales and investments in the past.
Cash was paid for the acquisition of equipment.
A longterm note for $ was issued for the acquisition of equipment.
Interest of $ and income taxes of $ were paid in cash.
QUEEN CORPORATION
Statement of Cash Flows
For the Year Ended December
Cash Flows from operating activites:
Net Income
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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