A company is considering two mutually exclusive projects requiring an initial cash outlay of $100 each and with a useful life of 5 years. The company required rate of return is 10% and the appropriate corporate tax rate is 40%. The projects will be depreciated on a straight line basis. The before depreciation and taxes cash flows expected to b generated by the projects are as follows.
Year | 1 | 2 | 3 | 4 | 5 |
Project A ($) | 4,000 | 4,000 | 10,000 | 2,000 | 1,000 |
Project B ($) | 6,000 | 3,000 | 2,000 | 5,000 | 5,000 |
Required
a) Determine the cashflow associated with the projects?
b) Which project should be accepted by using the appraisal method below;
In: Accounting
Ratio | 2018 | 2017 | 2016 | 2018-industry average | |
1 | Inventory turnover | 62.65 | 42.42 | 32.25 | 53.25 |
2 | Days's sales in receivables | 113 | 98 | 94 | 130.25 |
3 | Debt to Equity | 0.75 | 0.85 | 0.9 | 0.88 |
4 | Profit Margin | 0.082 | 0.07 | 0.06 | 0.075 |
5 | Total Asset Turnover | 0.54 | 0.65 | 0.7 | 0.4 |
6 | Quick ratio | 1.028 | 1.03 | 1.029 | 1.031 |
7 | Current ratio | 1.33 | 1.21 | 1.15 | 1.25 |
8 | Times interest Earned | 0.9 | 4.375 | 4.45 | 4.65 |
Required
You are asked to provide the shareholders with an assessment of the firm's asset management ,profitability,efficiency,solvency and leverage .Be as complete as possible given the above information ,but do not use any irrelevant information
In: Accounting
Calculate the project cash flow generated for Project A and Project B using the NPV method.
Sample Template for Project A and Project B:
“Table showing investments and returns for Project A and Project B. Project A has $10,000 initial investment with $5,000 returns in each of the first 3 years. Project B has $55,000 initial investment with $20,000 in each of the first 3 years.”
I am looking for the formulas to use. I believe I am using them incorrectly. Thanks!
In: Accounting
Jay Brooks prints and publishes study materials. He
has prepared the following trial balance as at 30 June
2017: Dr
Cr
$
$
Purchases 60 000
Inventory at 1 July 2016 10 000
Sales 120 000
Distribution costs 13 200
Administrative and selling expenses 5 600
Trade receivables 12 200
Discount allowed 1 550
Bank balance 4 150
Capital account at 1 July 2016 73 100
Discount received 2 500
6% Bank loan 10 000
Non-current assets at carrying amount 102 500
Capital introduced in the year 5 000
Loan interest paid 300
Drawings 8 000
Trade payables 5 600
Wages 15 000
Suspense 8 000
228 350 228 350
The following is to be taken into account.
Inventory valuation at 30 June 2017 was $12
000
Jay decided to write off an irrecoverable receivable
of $1 000. This should be accounted for as an administrative and
selling expense.
The wages cost should be split equally between cost of
sales and administrative and selling expenses.
Discounts allowed should be accounted for as an
administrative and selling expense.
The bank loan was taken out on 1 July 2016
The depreciation charge for the year of $5 000 on
property, plant and equipment has not yet been accounted for. It
should be classified as a cost of sale.
The balance on the suspense account represents the
proceeds from the disposal of an item of property, plant and
equipment. At the date of disposal, that item had a net carrying
amount of $10 000. The gain or loss on disposal should be accounted
for as a cost of sale.
Prepare the statement of profit or loss for the
year ended 30 June 2017, together with the statement of financial
position as at 30 June 2017 on behalf of Jay Brooks
In: Accounting
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $23.75 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:
Activity Cost Pool | Activity Measure | Activity for the Year | |
Cleaning carpets | Square feet cleaned (00s) | 12,000 | hundred square feet |
Travel to jobs | Miles driven | 193,000 | miles |
Job support | Number of jobs | 2,100 | jobs |
Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $349,000 which includes the following costs:
Wages | $ | 140,000 |
Cleaning supplies | 32,000 | |
Cleaning equipment depreciation | 9,000 | |
Vehicle expenses | 32,000 | |
Office expenses | 65,000 | |
President’s compensation | 71,000 | |
Total cost | $ | 349,000 |
Resource consumption is distributed across the activities as follows:
Distribution of Resource Consumption Across Activities | ||||||||||
Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | ||||||
Wages | 80 | % | 13 | % | 0 | % | 7 | % | 100 | % |
Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
Cleaning equipment depreciation | 66 | % | 0 | % | 0 | % | 34 | % | 100 | % |
Vehicle expenses | 0 | % | 83 | % | 0 | % | 17 | % | 100 | % |
Office expenses | 0 | % | 0 | % | 59 | % | 41 | % | 100 | % |
President’s compensation | 0 | % | 0 | % | 26 | % | 74 | % | 100 | % |
Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
1. Prepare the first-stage allocation of costs to the activity cost pools.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 54-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system.
4. The revenue from the Flying N Ranch was $142.50 (600 square feet @ $23.75 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 8%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $108 to purchase these supplies.
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:
Activity Cost Pool (Activity Measure) | Total Cost | Total Activity | |||
Customer deliveries (Number of deliveries) | $ | 249,000 | 3,000 | deliveries | |
Manual order processing (Number of manual orders) | 280,000 | 4,000 | orders | ||
Electronic order processing (Number of electronic orders) | 242,000 | 11,000 | orders | ||
Line item picking (Number of line items picked) | 700,000 | 400,000 | line items | ||
Other organization-sustaining costs (None) | 640,000 | ||||
Total selling and administrative expenses | $ | 2,111,000 | |||
Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Worley $37,000 to buy from manufacturers):
Activity |
||
Activity Measure | University | Memorial |
Number of deliveries | 13 | 22 |
Number of manual orders | 0 | 46 |
Number of electronic orders | 13 | 0 |
Number of line items picked | 150 | 220 |
Required:
1. Compute the total revenue that Worley would receive from University and Memorial.
2. Compute the activity rate for each activity cost pool.
3. Compute the total activity costs that would be assigned to University and Memorial.
4. Compute Worley’s customer margin for University and Memorial. (Hint: Do not overlook the $37,000 cost of goods sold that Worley incurred serving each hospital.)
In: Accounting
In: Accounting
At the beginning of the year, Young Company bought three used machines from Vince, Inc. The machines immediately were overhauled, were installed, and started operating. Because the machines were different, each was recorded separately in the accounts.
Machine A | Machine B | Machine C | |||||||
Amount paid for asset | $ | 8,150 | $ | 26,700 | $ | 10,400 | |||
Installation costs | 450 | 850 | 750 | ||||||
Renovation costs prior to use | 2,600 | 1,250 | 1,450 | ||||||
Repairs after production began | 510 | 460 | 600 | ||||||
By the end of the first year, each machine had been operating 6,000 hours.
Required:
Estimates | |||||||
Machine | Life | Residual Value | Depreciation Method | ||||
A | 5 | years | $ | 600 | Straight-line | ||
B | 20,000 | hours | 600 | Units-of-production | |||
C | 6 | years | 1,800 | Double-declining-balance | |||
In: Accounting
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 170,000 units and had the following actual costs: Direct materials $1,220,000 Direct labor 268,300 Supplies 39,600 Maintenance 32,250 Power 30,520 Supervision 99,400 Depreciation 76,000 Other overhead 244,300 Required: 1. Prepare a performance report for Nashler Company comparing actual costs with the flexible budget for actual units produced. If there is no variance, enter "0" for the amount and select "NA" in the last column. Nashler Company Performance Report Actual Cost Flexible Budget Cost Variance Direct materials $ $ $ Favorable Direct labor Unfavorable Supplies Unfavorable Maintenance Favorable Power Favorable Supervision Unfavorable Depreciation NA Other overhead Favorable Total cost $ $ $ Unfavorable Feedback Budgets can be used to examine the efficiency and effectiveness of a company. 2. What if Nashler Company’s actual direct materials cost were $1,224,000? How would that affect the variance for direct materials? If an amount is zero, enter "0". The materials variance would be $ . The total cost variance would increase by $ .
In: Accounting
Clair Walsh wishes to purchase a(n) $630,000 house. She has accumulated a $110,000 down payment, but she wishes to borrow $520,000 on a 25-year mortgage. For simplicity, assume annual mortgage payments occur at the end of each year and there are no loan fees.
1. |
What are Walsh's annual payments if her interest rate is (a) 44%, (b) 66%, and (c) 10%, compounded annually? |
2. |
Repeat number 1 for a 20-year mortgage. |
3. |
Suppose Walsh had to choose between a 25-year and a 20-year mortgage, either one at a(n) 66% interest rate. Compute the total payments and total interest paid on (a) a 25-year mortgage and (b) a 20-year mortgage. |
In: Accounting
Please pretend for a moment that you are the accounts receivable manager for JBX Industries, a local manufacturing company. JBX has the following issues as of 12/31/2017:
1. It is sitting on nearly $1 million in accounts
receivable.
2. However, almost $100,000 of that amount is expected to be
uncollectible.
3. JBX needs this cash to purchase additional raw materials for its
future sales.
What are some ways you could collect on these receivables? What kind of credit policies would you put in place to ensure you only took on the best clients?
In: Accounting
On January 1, the first day of the fiscal year, a company issues a $1,350,000, 11%, five-year bond that pays semiannual interest of $74,250 ($1,350,000 x 11% x ½), receiving cash of $1,512,610. Journalize the bond issuance. Refer to the Chart of Accounts for exact wording of account titles.
CHART OF ACCOUNTS- General Ledger
ASSETS- 110 Cash, 111 Petty Cash, 121 Accounts Receivable, 122 Allowance for Doubtful Accounts, 126 Interest Receivable, 127 Notes Receivable, 131 Merchandise Inventory, 141 Office Supplies, 191 Land, 194 Office Equipment, 195 Accumulated Depreciation-Office Equipment
LIABILITIES- 210 Accounts Payable, 221 Salaries Payable, 231 Sales Tax Payable, 232 Interest Payable ,241 Notes Payable,251 Bonds Payable, 252 Discount on Bonds Payable, 253 Premium on Bonds Payable
EQUITY- 311 Common Stock, 312 Paid-In Capital in Excess of Par-Common Stock, 315 Treasury Stock, 321 Preferred Stock, 322 Paid-In Capital in Excess of Par-Preferred Stock, 331 Paid-In Capital from Sale of Treasury Stock, 340 Retained Earnings, 351 Cash Dividends, 352 Stock Dividends, 390 Income Summary
REVENUE- 410 Sales, 610 Interest Revenue, 611 Gain on Redemption of Bonds
EXPENSES- 510 Cost of Merchandise Sold, 515 Credit Card Expense, 516 Cash Short and Over, 522 Office Salaries Expense, 531 Advertising Expense, 532 Delivery Expense, 533 Repairs Expense, 535 Rent Expense, 536 Insurance Expense, 537 Office Supplies Expense, 541 Bad Debt Expense, 562 Depreciation Expense-Office Equipment, 590 Miscellaneous Expense, 710 Interest Expense, 711 Loss on Redemption of Bonds
In: Accounting
On October 31, 2017, Cool Company sells a truck that originally cost 140,000 $ for 95,000$ cash. The truck was placed in service on January 1, 2012. It was depreciated using the straight-line method with an estimated salvage value of 28,000 and a useful life of 10 years. Record all the transaction. On July 19, 2018, Cool Co. purchased a machine for 260,000 SA from Saudi Machine Company (SMC). Omar gave SMC 7% note due in 120 days in payment for the machine. What is the maturity date of the note? How much interest will Omar pay to SMC on this note? Record the note? On October 16, 2018, Cool informs us that the company is unable to pay the note or interest?
In: Accounting
Oriental Hotel Bhd owned a few hotels in Malaysia. Their hotel in Melaka is set against a picturesque vista of Melaka’s most famous historical landmarks pf Melaka Raya. The location is close to Melaka City Centre with cheerful nightlife and mere minutes from the acclaimed UNESCO World Heritage site. The office management operates in the same hotel building as the hotel services provided to its guest. The company itself manages the hotel except for the laundry services which was transferred to its tenant, Cuci-Cuci Services Sdn. BHd.
Oriental Hotel Bhd take another step forward in its expansion plan with the opening a new hotel in the southern region in Malaysia. On 1 January 20X5, the company acquired a land for RM3,200,000 to construct a 4-star hotel building in Pangerang, Johor. Construction of the hotel building commenced on 1 March 20X5 and it was completed on 31 January 20X7, but was only used on 1 March 20X7.Total construction cost incurred excluding borrowing costs were RM34,000,000. The construction cost also includes the rectification of RM200,000. In order to finance the construction, the company took an 8%, 3 year-term loan of RM30,000,000 on 1 February 20X5. The company received a government grant of RM1,400,000 on 1 February 20X7 for the newly constructed hotel building. It is the company’s policy to use deferred income method for the government grant received.
Required:
Explain the accounting treatment for government grant received and
how will it differ from the alternative method.
In: Accounting
4. Greener Grass Fertilizer Company plans to sell 210,000 units of finished product in July and anticipates a growth rate in sales of 5 percent per month. The desired monthly ending inventory in units of finished product is 75 percent of the next month’s estimated sales. There are 157,500 finished units in inventory on June 30. Each unit of finished product requires 5 pounds of raw material at a cost of $1.25 per pound. There are 750,000 pounds of raw material in inventory on June 30.
Required:
Compute the company’s total required production in units of finished product for the entire three-month period ending September 30. (Round all intermediate calculations and your final answer to the nearest unit.)
Independent of your answer to requirement (1), assume the company plans to produce 800,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in that period. Compute the total estimated cost of raw-material purchases for the entire three-month period ending September 30.
In: Accounting