At year-end 2015, Wallace Landscaping’s total assets were $1.9 million and its accounts payable were $325,000. Sales, which in 2015 were $2.6 million, are expected to increase by 30% in 2016. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to $495,000 in 2015, and retained earnings were $260,000. Wallace has arranged to sell $160,000 of new common stock in 2016 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2016. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 8%, and 60% of earnings will be paid out as dividends.
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
What was Wallace's total long-term debt in 2015? Round your answer to the nearest dollar.
$
What were Wallace's total liabilities in 2015? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
How much new long-term debt financing will be needed in 2016? (Hint: AFN - New stock = New long-term debt.) Do not round intermediate calculations. Round your answer to the nearest dollar.
$
In: Finance
Following a strategy of product differentiation, Arseniq Company makes a high-end Appliance, XT15. Arseniq presents the following data for the years 2016 and 2017:
2016 2017
Units of XT15 produced and sold 50,000 52,500
Selling price $500 $550
Direct materials (square feet) 150,000 153,750
Direct materials costs per square foot $50 $55
Manufacturing capacity in units of XT15 62,500 62,500
Total conversion costs $6,250,000 $6,875,000
Conversion costs per unit of capacity $100 $110
Selling and customer-service capacity (customers) 150 150
Total selling and customer-service costs $2,250,000 $2,343,750
Selling and customer-service capacity cost per customer $15,000 $15,625
Arseniq produces no defective units but it wants to reduce direct materials usage per unit of XT15. Manufacturing conversion costs in each year depend on production capacity defined in terms of XT15 units that can be produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. Arseniq had 140 customers in 2016 and 145 customers in 2017.
Please post the answer in table form exactly like i posted please.
|
In: Accounting
Ambrose Inc. published the following financial statements in its 2016 annual report
Income statement
For the year ending December 31, 2016
sales $500,000
Cost of goods sold 350000
Gross profit 150,000
Operating expenses $75,000
Depreciation 20,000
95,000
EBIT 55,000
? Interest expense 20,000
EBT 35,000
? Tax Expense 12,250
EAT 22,750
Dividends 10,000
Addition to retained earnings$ 12,750
Sales in 2017 are estimated to be $650,000. Forecast the 2017 income statement, balance sheet, and statement of cash flow assuming:
Balance Sheet December 31, 2016
Cash $25,000
Marketable securities 10,000
Accounts receivable 50,000
Inventories 85,000
Plant, net 200,000
TOTAL ASSETS $370,000
Accounts payable 60,000
Accrued payables . 35,000
Bonds payable 140,000
Common stock 105,000
Retained earnings 30,000
Total Liabilities & Equity 370,000
sales in 2017 are estimated to be $650,000. Forecast the 2017 income statement, balance sheet, and statement of cash flow assuming:
(a) cost of goods sold, $30,000 of operating expenses and
depreciation are variable;
(b) the reminder of operating expenses is fixed;
(c) cash, accounts receivable, inventories, net plan, accounts
payable, and accrued payables are spontaneous;
(d) marketable securities, bonds payable, and common stock are
discretionary;
(e) $10,000 of bonds payable are current and will be repaid at the
beginning of the year; and
(f) the firm will maintain its 2016 dividend payout ratio in
2017.
In: Accounting
This assignment uses data structures, selection, use, control structures, logic, computation, file I/O, etc. In C++
There should be 3 files for the project: theMain.cpp, dateClass.h, dateClass.cpp (or similar file names)
For input/output. Read at least 10 dates in a data file set up this way:
The first number is the number of data items in the file. Then after that, each row is one date in the format month day year.
here is a sample data file of 6 elements:
6
1 1 2016
12 31 2011
11 01 -5506
13 02 2002
2 31 2020
2 21 2015
the output would be:
1 1 2016 would be: 1/1/16, January 1, 2016 and 1 January 2016
12 31 2011 would be: 12/31/11, December 31, 2011 and 31 December 2011
11 01 -5506 is an unknown date
13 02 2002 is an unknown date
2 31 2020 is an unknown date
2 21 2015 would be: 2/13/15, February 21, 2015 and 13 February 2015
if you program the main program similar to the example below, the output will be close to the example in the textbook. (the example below does not use files or a loop to read data)
#include <iostream>
#include <string>
#include "dateClass.h"
using namespace std;
int main()
{
Date aDate(3,15,2016);
aDate.displayShort();
aDate.displayLong();
aDate.displayGlbl();
cout << endl;
system("pause");
return 0;
} //end main
In: Computer Science
The asset side of the 2017 balance sheet for Oracle Corporation is below. The company reported total revenues of $37,728 million in 2017 and $37,047 million in 2016. Use this information to answer the required.
|
Oracle Corporation CONSOLIDATED BALANCE SHEETS (excerpts) |
||
|
in millions |
May 31, 2017 |
May 31, 2016 |
|
Current assets: |
||
|
Cash and cash equivalents |
$ 21,784 |
$ 20,152 |
|
Marketable securities |
44,294 |
35,973 |
|
Trade receivables, net of allowances for doubtful accounts of $319 and $327 as of May 31, 2017 and May 31, 2016, respectively |
5,300 |
5,385 |
|
Inventories |
300 |
212 |
|
Prepaid expenses and other current assets |
2,837 |
2,591 |
|
Total current assets |
74,515 |
64,313 |
|
Non-current assets: |
||
|
Property, plant and equipment, net |
5,315 |
4,000 |
|
Intangible assets, net |
7,679 |
4,943 |
|
Goodwill, net |
43,045 |
34,590 |
|
Deferred tax assets |
1,143 |
1,291 |
|
Other assets |
3,294 |
3,043 |
|
Total non-current assets |
60,476 |
47,867 |
|
Total assets |
$134,991 |
$112,180 |
Required:
a. What is the company’s gross amount of receivables at the end of 2017 and 2016?
b. Compute the common-size amount for gross accounts receivable, for both years. Interpret the year-over-year change in this ratio.
c. Compute the allowance for doubtful accounts to gross accounts receivable, for both years. Interpret the year-over-year change in this ratio.
d. Based on the ratios you calculated, form an opinion about the quality of the company’s accounts receivable.
In: Accounting
Gadgets Ltd has a division that represents a separate cash generating unit. At 30 June 2016, the carrying amounts of the assets of the division, valued pursuant to the cost model, are as follows:
|
Assets: |
$ |
|
Cash |
242,000 |
|
Plant and equipment |
600,000 |
|
Less: accumulated depreciation |
(200,000) |
|
Land |
800,000 |
|
Inventory |
190,000 |
|
Accounts receivable |
67,000 |
|
Patent |
200,000 |
|
Goodwill |
10,000 |
|
Carrying amount of cash generating unit |
1,909,000 |
The receivables were regarded as collectable, and the inventory’s fair value less costs to sell was equal to its carrying amount. The patent has a fair value less costs to sell of $180,000, and the land has a fair value less costs to sell of $780,000.
The directors of Gadgets estimate that, at 30 June 2016, the fair value less costs to sell of the division amounts to $1,750,000, while the value in use of the division is $1,840,000.
As a result, management increased the depreciation of the plant and equipment from $40,000 p.a. to $45,000 for the year ended 30 June 2017.
By 30 June 2017, the recoverable amount of the cash generating unit was calculated to be $20,000 greater than the carrying amount of the assets of the unit.
Required:
Determine how Gadgets Ltd should account for the results of the impairment test at 30 June 2016 and 30 June 2017, and prepare any necessary journal entries. Show all workings and provide references to the relevant accounting standard to support your answer.
|
Marking Guide - Question 5 |
Max. marks awarded |
|
Journal entries, calculations and workings for 2016 |
7.5 |
|
Journal entries, calculations and workings for 2017 |
7.5 |
In: Accounting
Problem 23-4A
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:
|
January |
February |
|||
| Sales | $375,840 | $417,600 | ||
| Direct materials purchases | 125,280 | 130,500 | ||
| Direct labor | 93,960 | 104,400 | ||
| Manufacturing overhead | 73,080 | 78,300 | ||
| Selling and administrative expenses | 82,476 | 88,740 |
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases are paid in cash in the month of
purchase, and the balance due is paid in the month following the
purchase. All other items above are paid in the month incurred
except for selling and administrative expenses that include $1,044
of depreciation per month.
Other data:
| 1. | Credit sales: November 2016, $261,000; December 2016, $334,080. | |
| 2. | Purchases of direct materials: December 2016, $104,400. | |
| 3. | Other receipts: January—Collection of December 31, 2016, notes receivable $15,660; | |
| February—Proceeds from sale of securities $6,264. | ||
| 4. | Other disbursements: February—Payment of $6,264 cash dividend |
The company’s cash balance on January 1, 2017, is expected to be
$62,640. The company wants to maintain a minimum cash balance of
$52,200
Prepare a cash budget for January and February in columnar form.
(Do not leave any answer field blank. Enter 0 for
amounts.)
- need excess (deficeinecy) of available cash over cash
disbrustments
Need Add: borrowing
need - add: repayments and ending cash balance
In: Accounting
Statement of Cash Flows
The following is a list of items for Witts Company's 2016 statement of cash flows:
receipt from sale of equipment, $2,700
increase in inventory, $3,900
net income, $13,500
payment for purchase of building, $29,000
depreciation expense, $8,700
receipt from issuance of bonds, $8,000
increase in prepaid expenses, $800
loss on sale of equipment, $2,200
payment of dividends, $5,200
decrease in accounts receivable, $1,700
issuance of common stock for land, $6,900
decrease in accounts payable, $1,500
beginning cash balance, $10,200
Required:
1. Prepare the statement of cash flows. Use a minus sign to indicate cash outflows, a decrease in cash or cash payments.
| WITTS COMPANY | ||
| Statement of Cash Flows | ||
| For Year Ended December 31, 2016 | ||
| Operating Activities: | ||
| $ | ||
| Adjustment for noncash income items: | ||
| Adjustments for cash flow effects from working capital items: |
||
| $ | ||
| Investing Activities: | ||
| $ | ||
| Financing Activities: | ||
| $ | ||
| $ | ||
| Cash, January 1, 2016 | ||
| Cash, December 31, 2016 | $ | |
2. If Witts Company uses IFRS, and chooses to show dividends as an operating activity, which of the following will result?
Witts Company would report net cash provided by operating activities of $25,100.
Witts Company would report net cash provided by operating activities of $14,700.
Witts Company would report net cash provided by financing activities of $2,800.
Witts Company would report net cash used by financing activities of $2,400.
In: Accounting
The following events took place for Video Wave Manufacturing Company during January 2016, the first month of its operations as a producer of digital video monitors:
| a. Purchased $137,200 of materials. | |
| b. Used $94,320 of direct materials in production. | |
| c. Incurred $180,640 of direct labor wages. | |
| d. Incurred $212,320 of factory overhead. | |
| e. Transferred $427,800 of work in process to finished goods. | |
| f. Sold goods with a cost of $360,250. | |
| g. Earned revenues of $655,000. | |
| h. Incurred $86,160 of selling expense. | |
| i. Incurred $70,250 of administrative expense. |
| Required: | |||||
Using the information given,
complete the following:
|
Amount Descriptions
| Amount Descriptions | |
| Administrative expenses | |
| Cost of goods sold | |
| Gross profit | |
| Net income | |
| Sales | |
| Selling expenses |
Income Statement
Using the information given, prepare the January 2016 income statement for Video Wave Manufacturing Company. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries.
|
Video Wave Manufacturing Company |
|
Income Statement |
|
For the Month Ended January 31, 2016 |
|
1 |
|||
|
2 |
|||
|
3 |
|||
|
4 |
Operating expenses: |
||
|
5 |
|||
|
6 |
|||
|
7 |
Total operating expenses |
||
|
8 |
Inventory Balances
Using the information given, determine the inventory balances at the end of the first month of operations.
| Materials | |
| Work in process | |
| Finished goods |
In: Accounting
| Clark Industries has a defined benefit pension plan that specifies annual retirement benefits equal to: |
| 1.5% × Service years × Final year’s salary |
|
Stanley Mills was hired by Clark at the beginning of 1997. Mills is expected to retire at the end of 2041 after 45 years of service. His retirement is expected to span 15 years. At the end of 2016, 20 years after being hired, his salary is $90,000. The company’s actuary projects Mills’s salary to be $370,000 at retirement. The actuary’s discount rate is 6%. Required:
|
In: Accounting