Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The instructions Plus an Excel file (you do need to match all the information from other worksheets to come up with the project Income Statement

The instructions

image text in transcribedimage text in transcribedimage text in transcribed

Plus an Excel file (you do need to match all the information from other worksheets to come up with the project Income Statement and Balance Sheet.

Sales and cash collection sheet

image text in transcribed

Purchases sheet

image text in transcribed

Purchase Disbursements sheet

image text in transcribed

Selling and Admin sheet

image text in transcribed

Cash Budget sheet

image text in transcribed

Please answer those Two Questions by showing how you got all the conclusions (Brief explanation please for thumbs-up)

  1. Prepare an absorption costing income statement for the quarter ended June 30.
  2. Prepare a balance sheet as of June 30. Please classify your balance sheet by separating out current assets from your non-current assets

This is an example (of different question !!!) for the income statement & balance sheet (That I want to see for the answers !!!)

image text in transcribed

image text in transcribed

PLEASE showing how you got all the conclusions!!

Below is the 2022 second quarter cash budget for Omni company, a wholesale distributor of consumer goods. ( Additional information: a) The sales budget was as follows: b) Cash collections were as follows: Schedule of expected cash collections: credit sales are collected in the month following sale 140% of the preceding month's sales. * Given. c) Merchandise purchases budget: d) Schedule of expected cash disbursements-merchandise purchases. One-half of a month's inventory purchases is paid for in the month of purchase; the other onehalf is paid for in the following month. *given Page 3 of 3 e) Opening capital was $120,000 plus the $1500 acquired this quarter f) Depreciation is $900 per month and includes depreciation on new assets g) Quarter end Accounts Receivable are based on 40% of June's sales. h) Quarter end Accounts Payable are based only on Purchase disbursements due from June. i) Common stock is $150,000 j) Retained earnings at the beginning of the quarter are $12,250

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

The Auditor Quo Vadis

Authors: Mervyn King, Linda De Beer

1st Edition

1138496774, 978-1138496774

More Books

Students also viewed these Accounting questions