Required information
Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3
[The following information applies to the questions
displayed below.]
Selected comparative financial statements of Korbin Company
follow:
| KORBIN COMPANY | |||||||||
| Comparative Income Statements | |||||||||
| For Years Ended December 31, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Sales | $ | 528,561 | $ | 404,921 | $ | 281,000 | |||
| Cost of goods sold | 318,194 | 253,481 | 179,840 | ||||||
| Gross profit | 210,367 | 151,440 | 101,160 | ||||||
| Selling expenses | 75,056 | 55,879 | 37,092 | ||||||
| Administrative expenses | 47,570 | 35,633 | 23,323 | ||||||
| Total expenses | 122,626 | 91,512 | 60,415 | ||||||
| Income before taxes | 87,741 | 59,928 | 40,745 | ||||||
| Income taxes | 16,320 | 12,285 | 8,271 | ||||||
| Net income | $ | 71,421 | $ | 47,643 | $ | 32,474 | |||
| KORBIN COMPANY | |||||||||
| Comparative Balance Sheets | |||||||||
| December 31, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Assets | |||||||||
| Current assets | $ | 49,834 | $ | 38,989 | $ | 52,119 | |||
| Long-term investments | 0 | 700 | 3,220 | ||||||
| Plant assets, net | 92,549 | 98,570 | 59,209 | ||||||
| Total assets | $ | 142,383 | $ | 138,259 | $ | 114,548 | |||
| Liabilities and Equity | |||||||||
| Current liabilities | $ | 20,788 | $ | 20,601 | $ | 20,046 | |||
| Common stock | 71,000 | 71,000 | 53,000 | ||||||
| Other paid-in capital | 8,875 | 8,875 | 5,889 | ||||||
| Retained earnings | 41,720 | 37,783 | 35,613 | ||||||
| Total liabilities and equity | $ | 142,383 | $ | 138,259 | $ | 114,548 | |||
1. Complete the below table to calculate each year's current ratio.
2. Complete the below table to calculate income statement data in common-size percents. (Round your percentage answers to 2 decimal places.)
3. Complete the below table to calculate the balance sheet data in trend percents with 2015 as the base year. (Round your percentage answers to 2 decimal places.)
|
|||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Recording Transactions (Including Adjusting and Closing Entries), Preparing Financial Statements, and Performing Ratio Analysis Ben and Kelly Perry began operations of their Roof repair company (Perry Roofing, Inc.) on January 1, 2015. The annual reporting period ends December 31. The trial balance on January 1, 2016, was as follows:
| Debit | Cash | |
| Cash | 12,000 | |
| Accounts receivable | 4,000 | |
| Supplies | 8,000 | |
| Equipment | ||
| Accumulated Depreciation (on equipement) | ||
| Other assets (not detailed to simplify) | 9,000 | |
| Accounts Payable | 14,000 | |
| Notes Payable | ||
| Wages Payable | ||
| Interest Payable | ||
| Income Taxes Payable | ||
| Unearned Revenue | ||
| Common Stock (60,000 shares, 0.10 par value) | 6,000 | |
| Additional Paid-in Capital | 9,000 | |
| Retained Earnings | 4,000 | |
| Service Revenue | ||
| Depreciation Expense | ||
| Supplier Expense | ||
| Wage Expense | ||
| Interest Expense | ||
| Income Tax Expense | ||
| Remaining Expense (not detailed to simplify) | ||
| Totals | 33,000 | 33,000 |
Transactions during 2016 follow:
a. Borrowed $28,000 cash on July 1, 2016, signing a one-year, 10 percent note payable.
b. Purchased equipment for $18,000 cash on July 1, 2016.
c. Sold 10,000 additional shares of capital stock for cash at $0.50 market value per share at the beginning of the year.
d. Earned $75,000 in revenues for 2016, including $16,000 on credit and the rest in cash.
e. Incurred remaining expenses of $35,000 for 2016, including $7,000 on credit and the rest paid with cash.
f. Purchased $3,000 of supplies on cash.
g. Collected accounts receivable, $8,000.
h. Paid accounts payable, $11,000.
i. Purchased $10,000 of supplies on account.
j. Received a $3,000 deposit on work to start January 15, 2017.
k. Declared and paid a cash dividend, $10,000.
Data for adjusting entries:
l. Supplies of $9,000 were counted on December 31, 2016.
m. Depreciation for 2016, $2,000.
n. Interest accrued on notes payable (to be computed).
o. Wages earned since the December 24 payroll but not yet paid, $3,000.
p. Income tax expense was $4,000, payable in 2017.
QUESTIONS TO ANSWER:
1. Set up T-accounts for the accounts on the trial balance and enter beginning balances.
2. Prepare journal entries for transactions (a) through (k) and post them to the T-accounts.
3. Journalize and post the adjusting entries (l) through (p).
4. Prepare an income statement (including earnings per share), statement of stockholders' equity, and balance sheet.
5. Identify the type of transaction for (a) through (k) for the statement of cash flows (O for operating, I for investing, F for financing), and the direction and amount of the effect.
6. Journalize and post the closing entry.
7. Compute the following ratios for 2016 and explain what the results suggest about the company:
a. Current ratio
b. Total asset turnover
c. Net profit margin
In: Accounting
USE C#
Maximum used policy
At the moment, AmSure Insurance Agency distributes exciting Life
Insurance Products, Health Insurance Products and Motor Insurance
Products. The company wants to find the policy type that has
maximum number of users. Given a CSV file with all the policy
details that are availed through Amsure, Write a program to find
the policy type which has maximum users using LINQ
statements.
Create a class Policy which include following
attributes,
| Data Type | Variable Name |
| int | _policyNumber |
| string | _insuranceType |
| DateTime | _startDate |
| DateTime | _renewalDate |
Include appropriate Properties as follows.
private string _name;
public string Name
{
get { return _name; }
set { _name = value; }
}
Create the policy.csv file which contain the policy details (ie)
policy number, insurance type, policy start date and policy renewal
date which is separated by comma.
Create a program class. Read the policy.csv file and store it into
the policy list. Write a LINQ query to find the policy type under
which maximum policies are there.
Input and Output Format:
Input consists of policy.csv file.
Output should display the policy type under which maximum policies
are there.
Sample input and output :
Input file policy.csv contain the details as
follows,
6435,Home Insurance,01-03-2016,10-07-2017
5234,Health Insurance,12-12-2014,06-01-2019
5614,Health Insurance,02-09-2015,03-11-2019
8575,Motor Insurance,07-11-2011,03-12-2017
8541,Health Insurance,01-11-2015,07-12-2016
4526,Motor Insurance,05-01-2017,13-09-2018
Output :
Health Insurance
In: Computer Science
Lab 11. Simple Harmonic Motion
Introduction
Lots of things vibrate or oscillate. A vibrating tuning fork, a moving child’s playground swing, and the speaker in a headphone are all examples of physical vibrations. There are also electrical and acoustical vibrations, such as radio signals and the sound you get when blowing across the top of an open bottle. Adding heat to a solid increases the vibration of atoms and molecules. One simple system that vibrates is a mass hanging from a spring. The force applied by an ideal spring is proportional to how much it is stretched or compressed. Given this force behavior, the up and down motion of the mass is called simple harmonic and the position can be modeled with
y = Asin(2πft +ф)
In this equation, y is the vertical displacement from the equilibrium position, A is the amplitude of the motion, f is the frequency (number of oscillations per second), t is the time, and ф is a phase constant that tells us the value of y at t = 0. This experiment will clarify each of these terms. The frequency where k is the spring constant and m is the mass.
Objectives
Task:
Complete the tables
Analysis Part 1: #3&4
Extension: #6
3. Does the frequency, f, appear to depend on the amplitude of the motion? Do you have enough data to draw a firm conclusion?
4. Does the frequency, f, appear to depend on the mass used? Did it change much in your tests?
6. Did the introduction of damping have a significant effect on the frequency? On the damping coefficient?
Data Tables
|
Run |
Mass (g) |
y0 (m) |
A(m) |
t(s) |
f (hz) |
|
1 |
200 |
.333 |
.05 |
.722 |
|
|
2 |
200 |
.333 |
.1 |
.724 |
|
|
3 |
300 |
.5 |
.05 |
.877 |
Find the spring constant: k=
|
Time (s) |
Position (m) |
|
|
When v=0 |
.248 |
|
|
When v=max |
.597 |
Ф=3.708
|
Fitted equation with parameters for run 3: y = A*sin(2πft + ф) + y0 |
|
Effect of damping |
||
|
Damping coefficient (s-1) |
Frequency (Hz) |
|
|
With damping |
.1393 |
1.124 |
|
Without damping |
0 |
1.138 |
In: Physics
Mackenzie Inc. uses a perpetual inventory system and has prepared the following adjusted trial balance on December 31, 2016:
Mackenzie Inc.
ADJUSTED TRIAL BALANCE
December 31, 2016
| ACCOUNT TITLE | DEBIT | CREDIT | |
|---|---|---|---|
|
1 |
Cash |
2,800.00 |
|
|
2 |
Accounts Receivable |
2,800.00 |
|
|
3 |
Allowance for Doubtful Accounts |
250.00 |
|
|
4 |
Inventory |
6,700.00 |
|
|
5 |
Prepaid Insurance |
800.00 |
|
|
6 |
Land |
5,900.00 |
|
|
7 |
Buildings and Equipment |
31,300.00 |
|
|
8 |
Accumulated Depreciation |
15,500.00 |
|
|
9 |
Accounts Payable |
3,200.00 |
|
|
10 |
Salaries Payable |
430.00 |
|
|
11 |
Unearned Rent |
360.00 |
|
|
12 |
Income Taxes Payable |
2,625.00 |
|
|
13 |
Note Payable |
4,800.00 |
|
|
14 |
Interest Payable |
750.00 |
|
|
15 |
Common Stock |
9,200.00 |
|
|
16 |
Retained Earnings |
7,320.00 |
|
|
17 |
Dividends |
1,300.00 |
|
|
18 |
Income Summary |
||
|
19 |
Sales Revenue |
32,120.00 |
|
|
20 |
Rent Revenue |
1,450.00 |
|
|
21 |
Cost of Goods Sold |
14,630.00 |
|
|
22 |
Selling Expenses |
4,900.00 |
|
|
23 |
Administrative Expenses |
3,500.00 |
|
|
24 |
Interest Expense |
750.00 |
|
|
25 |
Income Tax Expense |
2,625.00 |
|
|
26 |
Totals |
78,005.00 |
78,005.00 |
| For classification purposes: | |
| Note payable is due July 1, 2020 | |
| Interest payable is due July 1, 2020 |
| Required: | |
| Prepare in proper form for 2016 the company’s: | |
| 1. income statement | |
| 2. retained earnings statement | |
| 3. ending balance sheet | |
| 4. closing entries in its general journal |
CHART OF ACCOUNTSMackenzie Inc.General Ledger
| ASSETS | |
| 111 | Cash |
| 121 | Accounts Receivable |
| 122 | Allowance for Doubtful Accounts |
| 130 | Inventory |
| 131 | Prepaid Insurance |
| 180 | Land |
| 181 | Buildings and Equipment |
| 182 | Accumulated Depreciation |
| LIABILITIES | |
| 211 | Accounts Payable |
| 230 | Salaries Payable |
| 232 | Unearned Rent |
| 270 | Income Taxes Payable |
| 271 | Note Payable |
| 272 | Interest Payable |
| EQUITY | |
| 311 | Common Stock |
| 331 | Retained Earnings |
| 351 | Dividends |
| 391 | Income Summary |
| REVENUE | |
| 411 | Sales Revenue |
| 421 | Rent Revenue |
| EXPENSES | |
| 510 | Cost of Goods Sold |
| 625 | Selling Expenses |
| 699 | Administrative Expenses |
| 711 | Interest Expense |
| 910 | Income Tax Expense |
Prepare the company’s closing entries on December 31.
PAGE 12
GENERAL JOURNAL
| DATE | ACCOUNT TITLE | POST. REF. | DEBIT | CREDIT | |
|---|---|---|---|---|---|
|
1 |
Closing Entries |
||||
|
2 |
|||||
|
3 |
|||||
|
4 |
|||||
|
5 |
|||||
|
6 |
|||||
|
7 |
|||||
|
8 |
|||||
|
9 |
|||||
|
10 |
|||||
|
11 |
|||||
|
12 |
|||||
|
13 |
|||||
|
14 |
| Labels | |
| Contributed Capital | |
| Current Assets | |
| Current Liabilities | |
| Long-term Liabilities | |
| Operating expenses | |
| Other items | |
| Property, Plant, and Equipment | |
| Amount Descriptions | |
| Add: Net income for 2016 | |
| Gross profit | |
| Income before income taxes | |
| Income from operations | |
| Less: Dividends for 2016 | |
| Less: Net loss for 2016 | |
| Net income | |
| Net loss | |
| Retained earnings, December 31, 2016 | |
| Retained earnings, January 1, 2016 | |
| Total Assets | |
| Total current assets | |
| Total current liabilities | |
| Total Liabilities | |
| Total Liabilities and Shareholders’ Equity | |
| Total long-term liabilities | |
| Total operating expenses | |
| Total property, plant, and equipment | |
| Total Shareholders’ Equity |
prepare the company’s income statement for 2016. Additional Instructions
|
MACKENZIE INC. |
|
Income Statement |
|
For the Year Ended December 31, 2016 |
|
1 |
|||
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
|||
|
12 |
|||
|
13 |
|||
|
14 |
|||
|
15 |
|||
|
16 |
Earnings per share (1,500 shares) |
Prepare the statement of retained earnings for 2016. Additional Instructions
|
MACKENZIE INC. |
|
Statement of Retained Earnings |
|
For the Year Ended December 31, 2016 |
|
1 |
||
|
2 |
||
|
3 |
||
|
4 |
||
|
5 |
Refer to the Chart of Accounts and the list of Labels and Amount Descriptions provided for the exact wording of the answer choices for text entries.
“Less:” or “Plus:” will appear automatically, if needed.
Use the minus sign to indicate all negative values. For ex: Less: Accumulated depreciation is entered -### for (###).
Prepare the balance sheet at December 31, 2016. Additional Instructions
|
MACKENZIE INC. |
|
Balance Sheet |
|
December 31, 2016 |
|
1 |
Assets |
||
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
|||
|
12 |
|||
|
13 |
|||
|
14 |
|||
|
15 |
Liabilities |
||
|
16 |
|||
|
17 |
|||
|
18 |
|||
|
19 |
|||
|
20 |
|||
|
21 |
|||
|
22 |
|||
|
23 |
|||
|
24 |
|||
|
25 |
|||
|
26 |
|||
|
27 |
Shareholders’ Equity |
||
|
28 |
|||
|
29 |
|||
|
30 |
|||
|
31 |
|||
|
32 |
In: Accounting
You are a Junior Accountant for X-RAY Inc., and you receive from the CFO the following information which affects the Financial Statements of the company.
X-RAY Incorporate
Unadjusted Trial Balance 31.12.2016 Debit Credit
|
Cash |
43.820 |
|
|
Accounts receivable |
22.000 |
|
|
Supplies |
1.230 |
|
|
Prepaid Expenses |
5.200 |
|
|
Prepaid Interests |
18.750 |
|
|
Vehicles |
10.000 |
|
|
Computers |
3.000 |
|
|
Furniture |
8.000 |
|
|
Building |
55.000 |
|
|
Accumulated Depreciation |
7.000 |
|
|
ST Debt (Loan) |
25.000 |
|
|
LT Debt (Loan) |
100.000 |
|
|
Accounts payable |
2.000 |
|
|
Unearned Revenue |
10.000 |
|
|
Common stock |
5.000 |
|
|
Retained earnings |
18.000 |
|
|
Loss/Profit |
||
|
Total |
167.000 |
167.000 |
Required: Prepare the Journal, the Ledger, the adjusted Trial Balance, the Balance Sheet & Income Statement at 31/12/2016 considering the following business events not recorded yet in the financial statements.
Depreciation
|
Tangible Assets |
Cost of Acquisition |
Useful Life (Years) |
RV |
Date of Acquisition |
|
Vehicles |
10.000 |
5 |
2.500 |
01/03/2015 |
|
Buildings |
55.000 |
50 |
- |
01/06/2010 |
|
Computers |
3.000 |
3 |
- |
30/08/2016 |
|
Furniture |
8.000 |
10 |
1.000 |
30/04/2016 |
You are performing the year-end adjustments at 31/12/2016
Journalize the necessary entries for the transactions listed below at 31/12/2016 closing.
a) Calculate the Annual Depreciation Expense for all the Tangible Assets listed in the table before.
b) Journalize the Depreciation adjustments entries.
Accruals & Deferrals
Journalize the necessary entries for the transactions listed below at 31/12/2016 closing.
a) X-Ray Inc., where you work pays in advance 5.000 € of Rent Expense. The Rent contract is annual, and is signed every 30/04.
b) X-Ray Inc., receives and pays in advance every two months the Water Supply bill. The last bill was dated on 01/12/2016 for the Water consumption of December’16 and January’17, for 250
€.
c) Collects from a good client, 30.000 €, for a sales project to be started during the month of January 2017.
d) In 2015, signed a Sales contract of 10.000 €, and was fully paid in advance. The X-Ray Inc. Chief Financial Officer (CFO), estimates that at 31/12/2016 the project is 50% done.
e) In December 2016, the Company is informed that one of its vehicles has received a fine of 140
€ because of high speed driving. The due-date of the fine is at 30/03/2017.
Accounts Receivables
In the following graph, you can see a break-down of Accounts Receivables, along with its due dates.
|
Accounts Receivable |
Amount |
Due Date |
|
ECO 1, Ltd. |
2.500 |
30/06/2016 |
|
RESOMAG, Inc |
4.000 |
15/11/2016 |
|
TEKPLUS, S.A. |
5.500 |
15/02/2017 |
|
GIANT Inc. |
10.000 |
30/03/2017 |
|
Total |
22.000 |
Required:
Your boss, the CFO, asks you to perform the Bad-Debts calculations at year end 31/12/2016. He gives you the following instructions. Journalize the following events at 31.12.2016, following the CFO instructions:
1-) All the Accounts Receivables which are unpaid for more than 90 days, must be written-off. 2-) Allocate an Allowance for Doubtful accounts of 50%, for all the remaining unpaid accounts. 3-) Allocate an Allowance for Doubtful accounts for 5% for the remaining amount of Accounts Receivables.
Notes Receivables
X- Ray Inc. experiences the following business events regarding some Notes Receivables:
a) At 01/09/2016, performs two Sale Projects to INKJET SL: Project A for 35.000 €, and Project B for 15.000 €. We agree to receive both payments with a Notes Receivable with a maturity of 60 days.
b) As we need Cash, the CFO decides to discount Project A Notes, with the Bank. The expenses for bank services were €100, and the interest for discounting the notes was 3% of the total Amount.
c) At the maturity date, the Bank informs us that the client has paid 50% of the Notes Receivables of Project A. Project B remains fully unpaid.
d) The CFO decides to allocate 100% of Allowance of Bad Debts for the remaining amounts because he has red in the newspaper that INKJET SL went bankrupt.
Loans
At 01/01/2016, your company signs a Loan contract with CAIXABANK to fund a new project, with the following conditions:
Loan Amount: 125.000 €. Interest Rate: 5%. Term: 5 years. Payment of Interests: In advance the day of the loan signature.
In: Accounting
In c++ how do I search a vector for a name and then determine if the name is found?
In: Computer Science
What is the name of the following?

Including the cis or trans designation, what is the IUPAC name of the following substance?
It is not necessary to put cis or trans in italics.

Including the cis or trans designation, what is the IUPAC name of the following substance?
It is not necessary to put cis or trans in italics.

In: Chemistry
Refactor the following classes so they are both derived from a base class called Person. Write the code for the new base class as well. Try to avoid repeating code as much as possible. Write the classes so that any common methods can be invoked through a pointer or reference to the base class.
#include <string>
#include <cmath>
using namespace std;
class Student
{
private:
string name;
int age;
int studyYear;
public:
Student(string,int,int);
void study();
void eat();
};
Student::Student(string _name, int _age, int _studyYear)
{
name = _name;
age = _age;
studyYear = _studyYear;
}
void Student::study()
{
cout << name << " is studying."
<<endl;
}
void Student::eat()
{
cout << name << " is eating."
<<endl;
}
class Doctor
{
private:
string name;
int age;
int salary;
public:
Doctor(string,int,int);
void checkup();
void eat();
};
Doctor::Doctor(string _name, int _age, int _salary)
{
name = _name;
age = _age;
salary = _salary;
}
void Doctor::checkup()
{
cout << name << " is checking up."
<<endl;
}
void Doctor::eat()
{
cout << name << " is eating."
<<endl;
}
In: Computer Science
In Angel, you will find a class called Employee. This class should include a constructor which sets name to blanks and salary to $0.00 and a constructor which sets name to a starting name and salary to a set amount. Additionally, the class should include methods to set the name and salary and return the name and salary. Create another method to return the name and salary nicely formatted as a string (hint – research the toString method).
You will create a new class called Manager that inherits from the class Employee. Add a field named department of type String. Supply a method toStringthat prints the manager's name, department, and salary. Remember, you may not change anything in the Employee class.
You will then create a test class that uses the Manager class. The test class should prompt the user to enter name, department and salary. This information should be stored in an array. Upon entry of 3 employee records, the program should output the information you entered.
Your program should be able to handle a maximum of 3 entries.
You may write the program as a console application or using dialog boxes.
please write a code using java. Make sure the code is correct for java eclipse.
In: Computer Science