Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 70,000 Operating Expenses $ 63,000 Common Stock 100,000 Cash Flow from Investing Activities 79,400 Notes Receivable (short term) 25,000 Prepaid Rent 12,600 Allowance for Doubtful Accounts 7,900 Land 41,000 Uncollectible Accounts Expense 8,200 Cash 48,200 Supplies 1,300 Inventory 98,400 Interest Revenue 5,500 Accounts Payable 47,000 Sales Revenue 324,000 Salaries Payable 13,000 Dividends 3,600 Cost of Goods Sold 149,000 Interest Receivable (short term) 1,600 Accounts Receivable 57,000 Beginning Retained Earnings 81,500
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
SHERMAN EQUIPMENT CO.Balance SheetAs of December 31, Year 2AssetsTotal assetsLiabilities and Stockholders’ EquityCurrent LiabilitiesTotal LiabilitiesStockholders’ EquityTotal Stockholders’ EquityTotal Liabilities and Stockholders’ Equity
In: Accounting
(a) The following information relates to Bank HSBC. Prepare the profit & loss account for the year ended 31/12/2018. ( 8 mark)
|
Particulars |
OMR |
Particulars |
OMR |
|
Interest on cash credit |
892,000 |
Rent received |
72,000 |
|
Depreciation on bank property |
20,000 |
Exchange and commission |
32,800 |
|
Salaries and allowances |
218,800 |
Interest on fixed deposits |
1,100,000 |
|
Postage |
5,600 |
Interest on savings bank a/c |
272,000 |
|
Sundry charges |
4,000 |
Interest on overdraft |
216,000 |
|
Director’s and auditor’s fee |
16,800 |
Discount on bills discounted |
780,000 |
|
Printing |
8,000 |
Interest on current accounts |
168,000 |
|
Law charges |
3,600 |
Locker rent |
1,400 |
|
Interest on loans |
1,036,000 |
Transfer fee |
2,800 |
Provide for statutory reserve 25% and transfer OMR 12,000 to general reserve.
(b) Calculate the net premium to be credited to Revenue a/c from the following data (1 mark)
Premium during the year end OMR1,600,000
Reinsurance premium paid OMR 540,000
Reinsurance premium received OMR 620,000
Bonus in reduction of premium (not yet adjusted) OMR 20,000
(C)Compute the net commission to be debited to the revenue account, from the following information. (1mark)
Commission on direct business OMR 93,000
Commission on reinsurance accepted OMR 40,000
Commission on reinsurance ceded OMR 50,000
In: Accounting
Divisional Income Statements and Return on Investment Analysis
E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows:
Mutual Fund Division |
Electronic Brokerage Division |
Investment Banking Division |
||||
| Fee revenue | $1,010,000 | $1,060,000 | $1,030,000 | |||
| Operating expenses | 543,800 | 446,200 | 778,000 | |||
| Invested assets | 3,700,000 | 3,100,000 | 2,100,000 | |||
The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations.
Required:
1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges.
| E.F. Lynch Company | |||
| Divisional Income Statements | |||
| For the Year Ended June 30, 20Y8 | |||
| Mutual Fund Division | Electronic Brokerage Division | Investment Banking Division | |
| Fee revenue | |||
| Operating expenses | |||
| Income from operations | |||
2. Using the DuPont formula for rate of return on investment, compute the profit margin, investment turnover, and rate of return on investment for each division. Round your answers to one decimal place.
| Division | Profit Margin | Investment Turnover | ROI |
| Mutual Fund Division | |||
| Electronic Brokerage Division | |||
| Investment Banking Division |
In: Accounting
Question: The following three separate situations require adjusting journal entries to prepare financial statements as
of April 30. For each situation, present both:
∙ The April 30 adjusting entry.
∙ The subsequent entry during May to record payment of the accrued expenses.
Entries can draw from the following partial chart of accounts: Cash; Accounts Receivable; Prepaid
Interest; Salaries Payable; Interest Payable; Legal Services Payable; Unearned Revenue; Revenue; Salaries
Expense; Interest Expense; Legal Services Expense; Depreciation Expense.
a. On April 1, the company retained an attorney for a flat monthly fee of $3,500. Payment for April legal
services was made by the company on May 12.
b. A $900,000 note payable requires 12% annual interest, or $9,000, to be paid at the 20th day of each
month. The interest was last paid on April 20, and the next payment is due on May 20. As of April 30,
$3,000 of interest expense has accrued.
c. Total weekly salaries expense for all employees is $10,000. This amount is paid at the end of the day
on Friday of each five-day workweek. April 30 falls on a Tuesday, which means that the employees
had worked two days since the last payday. The next payday is May 3.
In: Accounting
Although Goldman Sachs paid Heather $90,000.00 per year, she was
not satisfied with her job. She had loved going white-water rafting
and skiing with her family in Utah since she was a little girl. So
last year, she decided to open her own business: Family Adventures.
During the summer, she takes families on different white-water
trips, and in the winter, she leads clients on skiing trips. To
start her business, Heather borrowed $100,000 from a bank and used
$70,000.00 of her savings. Her savings earned 10% interest. At the
end of the year, she wanted to know whether her new business
venture was worthwhile. The table below lists her total revenue and
itemized costs for Family Adventures.
|
Item |
Annual Dollar Value |
|
Total revenue |
$280,000.00 |
|
Employee wages |
$120,000.00 |
|
Rent on her business office |
$25,000.00 |
|
Payments on bank loan |
$10,000.00 |
|
Utility and gas expenses |
$5,000.00 |
1st attempt
Part 1 (0.5 point)
Feedback
See Hint
Family Adventures' accounting profit was $ .
Part 2 (0.5 point)
Feedback
See Hint
Family Adventures' economic profit was $ . (If the economic profit is less than zero, be sure to include the - sign.)
In: Accounting
Genesis Physical Therapy has been providing outpatient physical
therapy services for 30 years. The owners, Jesse and Janice, have
been slow to implement updated technology for the accounting system
because it is costly. However, at the beginning of the current
year, they decided to install a new patient revenue system. It is
an off-the-shelf product that is marketed to the healthcare
industry. The auditor asked one of Genesis’ accounting staff for
feedback about the new system. The staff member provided the
following comments:
| ● | “A frequent error has been occurring in which we invoice people who were past patients because they happened to have the same last name as one of our current patients.” |
| ● | We had a power outage a couple of weeks ago, and we had to re-enter all patient services that had been provided for that week because they had not been saved.” |
| ● | When we first starting using the system, we had a significant number of complaints from patients because they were being billed for more than their insurance would allow. We discovered a month later there was an error in the billing calculation formula in the system. We fixed the error and it has been functioning properly.” |
Evaluate the audit risks associated with the new patient revenue
system.
In: Accounting
Alibaba Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold, and the number of deliveries made.
The pizzeria’s cost formulas appear below:
|
Fixed Cost |
Cost per |
Cost per |
||||||||
|
Pizza ingredients |
$ |
4.10 |
||||||||
|
Kitchen staff |
$ |
6,070 |
||||||||
|
Utilities |
$ |
690 |
$ |
0.10 |
||||||
|
Delivery person |
$ |
2.90 |
||||||||
|
Delivery vehicle |
$ |
710 |
$ |
2.30 |
||||||
|
Equipment depreciation |
$ |
464 |
||||||||
|
Rent |
$ |
2,030 |
||||||||
|
Miscellaneous |
$ |
810 |
$ |
0.05 |
||||||
In November, the pizzeria budgeted for 1,800 pizzas at an average selling price of $15 per pizza and for 220 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
|
Actual Results |
|||
|
Pizzas |
1,900 |
||
|
Deliveries |
200 |
||
|
Revenue |
$ |
29,130 |
|
|
Pizza ingredients |
$ |
8,650 |
|
|
Kitchen staff |
$ |
6,010 |
|
|
Utilities |
$ |
925 |
|
|
Delivery person |
$ |
580 |
|
|
Delivery vehicle |
$ |
1,002 |
|
|
Equipment depreciation |
$ |
464 |
|
|
Rent |
$ |
2,030 |
|
|
Miscellaneous |
$ |
838 |
|
Required:
Compute the revenue and spending variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
| Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
| Pizza ingredients | $ | 4.40 | ||||||||
| Kitchen staff | $ | 5,910 | ||||||||
| Utilities | $ | 610 | $ | 0.30 | ||||||
| Delivery person | $ | 3.10 | ||||||||
| Delivery vehicle | $ | 630 | $ | 1.50 | ||||||
| Equipment depreciation | $ | 400 | ||||||||
| Rent | $ | 1,870 | ||||||||
| Miscellaneous | $ | 730 | $ | 0.15 | ||||||
In November, the pizzeria budgeted for 1,560 pizzas at an average selling price of $15 per pizza and for 220 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
| Actual Results | |||
| Pizzas | 1,660 | ||
| Deliveries | 200 | ||
| Revenue | $ | 25,450 | |
| Pizza ingredients | $ | 7,210 | |
| Kitchen staff | $ | 5,850 | |
| Utilities | $ | 885 | |
| Delivery person | $ | 620 | |
| Delivery vehicle | $ | 986 | |
| Equipment depreciation | $ | 400 | |
| Rent | $ | 1,870 | |
| Miscellaneous | $ | 790 | |
Required:
1. Compute the revenue and spending variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
"A firm is considering purchasing a new milling machine and has
collected the following information for its income statement and
cash flow statement. However, this income statement was calculated
as if there is no inflation! All dollars are expressed in constant
(year-0) dollars. Recalculate the income and cash flow statement by
assuming there is a general (average) inflation of 2.6% applied to
revenue, O&M, and salvage value.
- The firm will pay back the loan in 2 years, and the annual loan
payment is $26,571.
- The tax rate is 38%.
- The revenue for year 1 is $40,000 and $36,000 for year 2.
- O&M for year 1 is $8,000 and $11,000 for year 2.
- The interest paid on the debt is $2743 for year 1 and $1409 for
year 2.
- The taxable income is $19,111 for year 1 and $14,897 for year
2.
- The income taxes are $7,262 for year 1 and $5,661 for year
2.
- The milling machine costs $71,000.
- The salvage value at the end of year 2 is $48,000.
Calculate the IRR of the cash flow based on actual dollars. Express
your answer as a percentage between 0 and 100.
You should calculate the depreciation based on the information
given in the problem, but do not refer to the MACRS table. You will
also need to calculate the amount that is borrowed and that goes to
the principal on the debt in years 1 and 2."
In: Finance
Lance, the owner of Onya Bikes, informs you that he has completed all adjusting journal entries. He provides the following adjusted ledger balances for the year ended 31 December 2020.
|
$ |
|
|
Accounts payable |
29,300 |
|
Accounts receivable |
45,220 |
|
Accumulated depreciation: Equipment |
84,050 |
|
Allowance for doubtful debts |
9,000 |
|
Bad debts expense |
6,000 |
|
Cash at bank |
15,660 |
|
Cost of sales |
227,100 |
|
Depreciation expense - equipment |
20,100 |
|
Equipment |
191,790 |
|
GST Clearing (owing to Tax Office) |
8,550 |
|
Insurance expense |
16,610 |
|
Interest payable |
6,250 |
|
Inventory |
25,500 |
|
Lease Expense |
4,000 |
|
Lance, Capital: 1January |
102,600 |
|
Lance, Drawings |
71,240 |
|
Loan from Best Bank (due 2025) |
125,000 |
|
Prepaid rent |
2,000 |
|
Rent expense |
26,000 |
|
Sales returns |
14,000 |
|
Sales revenue |
484,000 |
|
Supplies expense |
8,640 |
|
Supplies on hand |
4,400 |
|
Unearned revenue |
8,500 |
|
Utilities expense |
26,040 |
|
Wages expense |
152,950 |
Required:
Prepare/answer the following:
a. An Income Statement for the year ended 31 December 2020. (Classification of expenses not required) (8 marks)
b. A Statement of Changes in Equity for the year ended 31 December 2020.
c. A classified Balance Sheet as at 31 December 2020.
In: Accounting