PLEASE SHOW ALL WORK step by step and very clear!!

The Joe K Company is examining purchasing a new piece of equipment and has hired you to evaluate the project.

The old system is currently two years old and had an original production life of six years. It had cost $9,600,000 and had been depreciated with 100% bonus depreciation. Joe estimated that it could be sold for $1,300,000 at the end of its production life and this is still true.

The new will take one year to build and install and require an investment of $5,700,000 today and $1,500,000 one year from now. It will have a production life of five years and be depreciated as 100% bonus. We will also increase working capital by $200,000 when it is ready for use.

The old is projected to produce revenue of $4,400,000 this coming year and that will decrease 15% per year for the rest of its production life. Expenses are expected to be 50% of revenue (not including depreciation and taxes). The old will be used until the new is put in service.

The new will produce $3,600,000 its first year of production, $6,200,000 its second year, $7,400,000 its third year, $5,400,000 its fourth year and $3,900,000 its last year. Expenses are expected to be 45% of revenue (not including depreciation and taxes). We expect to sell it for $1,600,000 at the end of its production life. We estimate we can sell the working capital for $200,000 at that time.

We estimate that the old could be sold for $2,600,000 when the new is ready for use.

Joe requires a 14% return on this project and has a 30% tax rate. Based on net present value, should he purchase the new system? SHOW ALL WORK!!!!!

The IRR on this project would be:

J.T.Pan and​ Company, a manufacturer of quality handmade walnut​ bowls, has had a steady growth in sales for the past 5 years.​ However, increased competition has led Mr.Pan​, the​ president, to believe that an aggressive marketing campaign will be necessary next year to maintain the​ company's present growth. To prepare for next​ year's marketing​ campaign, the​ company's controller has prepared and presented Mr.Pan with the following data for the current​ year, 2017​:

Requirements:

1. Weka Company Ltd has been considering the criteria that must be met before a capital expenditure proposal can be included in the capital expenditure programme. The screening criteria established by management are as follows:

1. No project should involve a net commitment of funds for more than four years.
2. Accepted proposals must offer a time adjusted or discounted rate of return at least equal to the estimated cost of capital. Present estimates are that cost of capital is 15 percent per annum after tax.
3. Accepted proposals should average over the lifetime, an unadjusted rate of return on assets employed (calculated in the conventional accounting method) at least equal to the average rate of return on total assets shown by the statutory financial statements included in the annual report of the company.

A proposal to purchase a new lathe machine is to be subjected to these initial screening processes. The machine will cost Sh2,200,000 and has an estimated useful life of five year at the end of which the disposal value will be zero.

Sales revenue to be generated by the new machine is estimated as follows:

Additional operating costs are estimated to be Shs700,000 per annum. Tax rates may be assumed to be 30% payable in the year in which revenue is received for taxation purpose the machine is to be written off at a fixed annual rate of 20% on cost.

The financial accounting statement issued by the company in recent years show that profits after tax have averaged 18% on total assets.

Required

Present a report which will indicate to management whether or not the proposal to purchase the lathe machine meets each of the selection criteria.

Q1) A project requires an initial investment of $5,000. It is expected that the project will last 3 years and generate net cash flows of $3,500 for each of these years. If the discount rate for the project is 10%, the discounted payback period for the project.is:

Select one:

a. 1.63 years

b. 2.55 years

c. 1 year

d. More than 3 years

Q2) Capital rationing refers to the limiting of capital resources to under-performing divisions.

Select one:

True

False

Q3) A new project will generate annual revenue of $370,000 and will entail operating expenses of $150,000. The annual depreciation and amortisation for the assets used in the project will equal $50,000. An annual capital expenditure of $20,000 will be required to offset wear and tear on the assets used in the project but no additions to working capital will be required. The company tax rate will be 25 percent. What is the incremental annual free cash flow for the project?

Select one:

a. $150,500

b. $149,500

c. $157,500

d. None of the provided choices

Q4) RXP Ltd is a producer of tablet computers, and has already five different models selling in the market. The company is now considering a project that involves the launch of a new tablet computer model. The company's market analysts predict that the new model will be sold at a rate of 10,000 units per year and at a price of $500 per unit. However, the analysts further predict that the launch will decrease the sales revenue from existing models by about $1m per year. Given the scenario, please state whether the following statement is True or False:

While evaluating the project, the company should consider the decrease of sales revenue from existing models.

Select one:

True

False

1. The adjusted account balances of Fitness Centre at July 31 are as follows: Accounts Account Balances Accounts Account Bal Cash $ 11,000 Service Revenue $105,000 Accounts Receivable 25,000 Interest Revenue 8,000 Supplies 4,000 Depreciation Expense 27,000 Prepaid Insurance 8,000 Insurance Expense 6,000 Buildings 300,000 Salary Expense 30,000 Accumulated Depreciation— Supplies Expense 9,000 Buildings 120,000 Utilities Expense 12,000 Accounts Payable 19,000 P. Jorgenson, Capital 195,000 P. Jorgenson, Drawings 15,000 Instructions Prepare the end of the period closing entries for the Fitness Centre.

2. The following are the adjusted account balances of Sally's Salon and Spa as at June 30, 2017, the business year end. The accounts are listed in alphabetical order, and all are in their normal balance. Accounts payable $ 2,340 Note receivable $ 5,000 Accounts receivable 500 Prepaid insurance 620 Accumulated depreciation - computers 2,000 Rent expense 24,000 Accumulated depreciation - shop equipment 6,320 S. Juul-Hansen, capital 11,760 Cash 3,250 S. Juul-Hansen, drawings 12,000 Computers 6,000 Service revenue 125,600 Depreciation expense 4,160 Shop equipment 15,800 Insurance expense 2,000 Supplies 1,190 Interest expense 100 Supplies expense 4,560 Note payable 14,000 Wages expense 82,840 Additional information: The note payable is due January 31, 2018. During the year, Sally Juul-Hansen invested $10,000. Instructions Prepare the income statement, statement of owner equity, and classified balance sheet for Sally's June 30, 2017 year end in good format.

You are the head of project selection for Broken Arrow Records (BAR). Your team is considering three new projects, each with a unique sound and style. Based on past history, management requires a 20% rate of return. Additionally, they have allocated $1 million toward the production of these albums. Finally, management wants you to find new talent without taking risks. So, give the following weights to projects;

New Artist = 10, Risk = 6, Genre = 3, Diversity = 2

Given the following information about each project, prioritize each project. That is, put them in order of which BAR should do first, second, and third; money permitting, of course.

Note: You will use the Project Selection Matrix, the Payback Period, and the NPV to make your decision.

Project: Time Fades Away

            New Artist: 10

            Risk: -10

Genre: 7

            Diversity: 3

Project: Tears in the Rain

            New Artist: 5

            Risk: -5

Genre: 9

            Diversity: 2

Project: On the Beach

            New Artist: 2

            Risk: -2

Genre: 3

            Diversity: 2

SHOW EXCEL FORMULAS

PLEASE answer number 2 (worksheet) I am really struggling with it.

Below is the unadjusted trial balance for Walton Anvils as of December 31, 2016, and the data for the adjustments. There is also an Excel Template for this problem that you may download and use (or you may use your own).

Adjustment Data

Requirements

1.Open T-accounts using the balances in the unadjusted trial balance.

2.Complete the worksheet for the year ended December 31, 2016.

3.Prepare the adjusting entries and post to the T-accounts.

4.Prepare the adjusted trial balance.

5.Prepare the income statement, the statement of retained earnings, and the classified balance sheet in report form.

6.Prepare the closing entries and post to the T-accounts.

7.Prepare a post-closing trial balance.

8.Calculate the current ratio for the company.

The General Manager of The Cougar Hotel would like you to take the balances for 20X7 and

20X8 and;

1.   Prepare a comparative Summary Operating Statement that is in compliance with the USALI 11th Edition (i.e. make sure it is in the correct format, use the template found in the Income Statement module or in the “Other Course Resources” folder).

2.   Once the Summary Operating Statement has been completed, perform a vertical and horizontal analysis of the statement.

THE COUGAR HOTEL 20X7                     20X8

Administrative and General                                                  1,426,678             1,460,830

Beverage Revenue                                                                  1,333,039             1,337,700

Building Wall Rent Received                                                                                  250,000

Cell Tower Rent Received                                                         500,000

Food and Beverage                                                                 3,999,116             4,122,300

Food and Beverage Expenses                                                4,265,724             4,340,000

Gain on Sale of Equipment                                                                                     150,000

Inforamation and Telecommunications Systems                  281,813                267,225

Insurance                                                                                     264,200                285,040

Loss on Sale of Equipment                                                        200,000

Management Fees                                                                     528,399                534,450

Miscellaneous Income                                                               447,213                385,000

Property and Other Taxes                                                          704,532                694,785

Property Operating and Maintenance                                     563,626                623,525

Recreation Department                                                             440,333                450,450

Recreation Department Expenses                                           577,937                567,000

Replacement Reserve                                                            1,409,065             1,425,200

Room Revenue                                                                      10,733,112           10,815,000

Rooms Department Expenses                                               2,992,887             3,010,000

Sales and Marketing                                                               1,268,158             1,371,755

Spa Expenses                                                                               385,291                378,000

Spa Revenue                                                                                660,499                704,550

Utilities                                                                                        792,599                748,230

CHECK FIGURES:

These are totals that you can use to check and see if your math is correct and also check if you have figures placed correctly.

20X7                     20X8

Total Departmental Profit                                                     9,391,473             9,520,000

Gross Operating Profit                                                           5,058,599             5,048,435

EBITDA Less Replacement Reserve                                     2,452,403             2,508,960

The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for the year ended December 31, 2018 ($ in 000s): sales revenue, $16,500; cost of goods sold, $6,800; selling expenses, $1,360; general and administrative expenses, $860; interest revenue, $120; interest expense, $240. Income taxes have not yet been recorded. The company’s income tax rate is 40% on all items of income or loss. These revenue and expense items appear in the company’s income statement every year. The company’s controller, however, has asked for your help in determining the appropriate treatment of the following nonrecurring transactions that also occurred during 2018 ($ in 000s). All transactions are material in amount. Investments were sold during the year at a loss of $280. Schembri also had unrealized gains of $380 for the year on investments. One of the company’s factories was closed during the year. Restructuring costs incurred were $1,800. During the year, Schembri completed the sale of one of its operating divisions that qualifies as a component of the entity according to GAAP. The division had incurred a loss from operations of $620 in 2018 prior to the sale, and its assets were sold at a gain of $1,520. In 2018, the company’s accountant discovered that depreciation expense in 2017 for the office building was understated by $260. Negative foreign currency translation adjustment for the year totaled $300. Required: 1. Prepare Schembri’s single, continuous multiple-step statement of comprehensive income for 2018, including earnings per share disclosures. One million shares of common stock were outstanding at the beginning of the year and an additional 400,000 shares were issued on July 1, 2018. 2. Prepare a separate statement of comprehensive income for 2018.

1. Mansfield Office Furniture Store reported the following selected items at December 31, 2019 (previous year - 2018 - amounts are also given as needed):

Compute Mansfield's

acid-test ratio; (b) accounts receivable turnover ratio (round to 2 decimal places); and (c) days' sales in receivables for 2019 (round to the nearest day). Show your computations

2. The following is the adjusted trial balance for Baker Services.

There were no new capital contributions during the year. After the closing entries are posted, what is the balance in Baker, Capital? Please show your calculations: