· Evaluate these projects using your sensitivity analysis. · Discuss how using expected values could help analyse the projects. · Should CarMaker Ltd. take account of inflation in their analysis of the two plants?

Strategic Corporate Finance for CarMaker Ltd
Paper, Order, or Assignment Requirements

Introduction

You work at the headquarters of CarMaker Ltd. and are responsible for the evaluation of capital investment projects. The business is currently trying to decide between 2 proposed manufacturing plants in Yorkshire. Each manufacturing plant has an expected life of 10 years but one is a larger investment. At the end of the 10 years the small plant will be sold for £1.8 million and the large plant for £6.5million.

Revenue and costs

Revenue will come from selling the cars in the European market. The revenue per car is expected to be £12,000 for the small plant and £10,000 for the large plant over the time period being examined.

The manufacturing plants are expected to produce the following number of cars per year.

Small plant: 500 cars in year 1, 1,000 for the remaining years.

Large plant: 500 cars in year 1, 2,200 in years 2 and 10, and 5,000 for the remaining years.

The investment will be financed through a loan from Yorkshire Bank.

Below is the accountant’s list of costs associated with each project and timing of payments.

Summary of costs (and year in which cash flow occurs) Small Large
Investment costs £’000 £’000
Preparatory costs (planning, legal etc) 100 1000
Land Purchase Cost (year 0) 28,000 100,000
Total Interest expense 372 744
Equipment (year 1) 16,070 58,035
Grid connection (year 0) 500 500
Refurbishment of Equipment (year 5) 7000 19,000
52,042 179,279
Less government grant 600 100
Net capital cost 51,442 179,179

The accountant has prepared the following forecast profit and loss accounts for the life of the projects.

Small Manufacturing Plant: projected profit and loss accounts (£’000)
Year 1 2 3 4 5 6 to 9 10
Sales 6,000 12,000 12,000 12,000 12,000 12,000 12,000
Government grant 60 60 60 60 60 60 60
Total revenue 6,060 12,060 12,060 12,060 12,060 12,060 12,060
Annual operating costs
Insurance 250 250 250 250 250 250 250
Business rates 50 50 50 50 50 50 50
Wages 750 750 750 750 750 750 750
Annual management fee 25 25 25 25 25 25 25
Other Annual Running costs 390 390 390 390 390 390 390
Interest expense 100 90 74 48 30 20 10
Depreciation 1,607 1,607 1,607 1,607 1,607 1,607 1,607
3,172 3,162 3,146 3,120 3,102 3,092 3,082

Profit/(loss) 2,888 8,898 8,914 8,940 8,958 8,968 8,978

Large Manufacturing Plant: projected profit and loss accounts (£’000)
Year 1 2 3 4 5 6 to 9 10
Sales 5,000 22,000 50,000 50,000 50,000 50,000 22,000
Government grant 10 10 10 10 10 10 10
Total revenue 5,010 22,010 50,010 50,010 50,010 50,010 22,010
Annual operating costs
insurance 900 900 900 900 900 900 900
Business rates 100 100 100 100 100 100 100
Wages 2,400 2,400 2,400 2,400 2,400 2,400 2,400
Annual management fee 95 95 95 95 95 95 95
Other Annual Running costs 1,580 1,580 1,580 1,580 1,580 1,580 1,580
Interest Expense 200 180 148 96 60 40 20
Depreciation 5,804 5,804 5,804 5,804 5,804 5,804 5,804
11,079 11,059 11,027 10,975 10,939 10,919 10,899

Profit/(loss) -6,069 10,952 38,984 39,036 39,072 39,092 11,112

Further information

The following information is also available

a) Payments and receipts arise at the year ends unless otherwise stated

b) The project is expected to have an anticipated life of 10 years.

c) All costs and revenues are expressed at today’s prices (year zero) with no allowance for inflation.

d) The government grant will be received in year 0. However it has been spread over the life of the project in the profit and loss accounts

e) The preparatory costs have already been incurred.

f) The annual management fees for both projects include a fee of £15,000 which is an apportionment of head office overheads.

g) The refurbishments in year 5 require the use of specialised equipment that will be borrowed from another division of the Company. This will cost the other division additional hire costs of £100,000 per project and is not reflected in the profit and loss accounts

h) An initial cash reserve is needed for each project. It will be paid back at the end of year 10.

o Small £1.5 million

o Large £2 million

i) Ignore corporation tax.

j) The CarMaker Ltd. has a cost of capital (discount rate) of 12%.

k) They have a current return on capital employed of 15% and this is expected to be met by new projects.

l) They expect projects to have a payback period of no more than 5 years.

Required:

Task 1 Calculations (using the spreadsheet)

a) Enter relevant figures into the cash flows worksheet and justify any adjustments to the profit and loss accounts as a result of the information in points a)-l) above.

b) Using the figures in the calculations worksheet for Net present value (NPV), Internal Rate of Return (IRR), accounting rate of return (ARR) and Payback Period, state, with reasons which project you would accept.

c) Use the sensitivity worksheet to prepare a sensitivity analysis for each project by adjusting each variable +/- 10%.

Use the spreadsheet provided to enable you to undertake all necessary calculations. You must use this spreadsheet.

(40 marks)

Task 2 Risk

You are not expected to do any calculations for this task.

· Evaluate these projects using your sensitivity analysis.

· Discuss how using expected values could help analyse the projects.

· Should CarMaker Ltd. take account of inflation in their analysis of the two plants?

Credit will be given in this task for appropriate use of academic literature along with accurate citations and referencing using the Harvard system.

(60 marks)

Additional Information

Methods of working

You are expected to the use the assignment 1 spreadsheet for your calculations. This should be uploaded to Moodle along with your written work.

Assignment 1 spreadsheet

There are 4 worksheets in this workbook to help you with your assignment (cash flows, calculations, sensitivity worksheet and sensitivity answers).

Cash flows worksheet:

Enter all cash flows and a discount rate. Use this information to calculate the present value of each year’s cashflows.

Calculations worksheet: Use the cells provided to calculate the NPV, IRR, ARR and Payback period for each project.

Sensitivity worksheet: Use this worksheet to adjust the different variables by +/- 10% and see the effect on the NPV and IRR. See seminar examples of how to work with this tab.

Sensitivity answers

Enter your answers to the sensitivity analysis in the lighter shaded cells.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Complete the financial statements using the proposed parallel classification scheme of the financial statements.

Project for accounting
Paper, Order, or Assignment Requirements

For month ending January 31, 2014

ONE MONTH OF TRANSACTIONS– A Manual Accounting System
YourName Boating Distributors, a wholesale-retail boating distributor is incorporated in the State of New Jersey, with an authorized capitalization of 400,000 shares of $5.00 par value common stock (1,000 shares outstanding as of January 1). The company’s accounting system includes a General journal, General ledger, Accounts receivable subsidiary ledger, and Accounts payable subsidiary ledger

The transactions and accounting records in this set have been selected to give the student an understanding of the interrelationships in an accounting system. While almost all companies employ computerized accounting systems, this set is initially structured around a manual system with only one journal to permit maximum student learning.

The company recognizes one month’s depreciation in the month that an asset is purchased or sold. Also, it is assumed that the company closes its books monthly.

The post-closing trial balance of YourName Boating Distributors as of December 31 (which was the year- end) was as follows:
Debits Credits

Cash ………………………………………………………………….. $25,100
Accounts Receivable ………………………………………………… 35,000
Allowance for Doubtful Accounts …………………………………… $ 400
Merchandise Inventory ………………………………………………. 76,000
Investments (available-for-sale)……………………………………….. 11,500
Office and Store Supplies ……………………….…………………. 1,800
Prepaid Insurance ……………………………………………………. 600
Prepaid Rent …………………………………………………………. 3,000
Office Equipment ……………………………………………………. 20,000
Accumulated Depreciation—Office Equipment …………………….. 4,000
Warehouse Storage Equipment ………………….…………………… 35,000
Accumulated Depreciation—Warehouse Equipment ………………… 8,000
Accounts Payable ……………………………………………………. 19,000
Interest Payable ……………………………………………………… 100
Employees’ Federal Income Taxes (withhold) Payable …………………………. 700
FICA Taxes Payable …………………………………………………. 400
Short-term Notes Payable (Galindo City Bank, 60-day, 12 percent,
Dated (December 1) ………………………………………… 10,000
Common Stock (par $5.00) …………………………………………… 5,000
Additional Paid in Capital……………………………………………… 40,000
Accumulated Other Comprehensive Income ………………………….. 1,500
Retained Earnings ……………………………………………………… 118,900

Totals ………………………………………………………….. $208,000 $208,000

CHART OF ACCOUNTS YOURNAME BOATING
2014

Account Number Account Name
101 Cash
102 Accounts Receivable
103 Allowance for Doubtful Accounts
109 Investments–Available for Sale Securities Short-term Assets
110 Merchandise Inventory
119 Office and Store Supplies
120 Prepaid Insurance
121 Prepaid Rent
122 Office Equipment
123 Accumulated Depreciation—Office Equipment
124 Warehouse Equipment Long-term Assets
125 Accumulated Depreciation—Warehouse Equipment
170 Building
171 Accumulated Depreciation–Building
201 Accounts Payable
203 Interest Payable
209 Salaries Payable
219 Employees’ Federal Income Taxes (withheld) Payable
225 FICA Taxes Payable Short-term Liabilities
240 Short-term Notes Payable
250 Dividends Payable
251 Income Taxes Payable (Corporation)
280 Bonds Payable
281 Discount or Premium on Bonds Payable Long-term Liabilities
301 Common Stock
302 Additional Paid-In Capital
340 Accumulated Other Comprehensive Income
350 Retained Earnings Equity Accounts
390 Treasury Stock
413 Sales
414 Sales Returns and Allowances
415 Sales Discounts
510 Cost of Goods Sold
612 Depreciation Expense—Office Equipment
613 Depreciation Expense—Warehouse Equipment
614 Depreciation Expense–Building
615 Office Salaries Expense
616 Sales Salaries Expense
617 Payroll Tax Expense
618 Interest Expense Income Statement
619 Insurance Expense
620 Rent Expense
651 Office and Store Supplies Expense
655 Advertising Expense
656 Bad Debts Expense
657 Repairs Expense, Office
658 Utilities Expense
659 Income Tax Expense
701 Realized Gains or Losses on Sale of Assets
703 Investment Income Nonoperational
801 Unrealized Gains/Losses–Available-For-Sale Securities Other comprehensive
Income

1You may not need all these accounts, or you may have to add an account.

ACCOUNTS RECEIVABLE SUBSIDIARY LEDGER
Balances as of December 31

Glassboro SeaWorld $ 1,000
Paige Connery Best Buys 0
Buena by the Shore 13,500
Evan Hughes Price Boats 10,000
Parth Patel’s Boats 10,500
$ 35,000

ACCOUNTS PAYABLE SUBSIDIARY LEDGER
Balances as of December 31

Jonathan Horvat Boat Suppliers 10,500
Szumowski’s’s Boats 5,000
Emily Falk’s Boats 0
Mathew Hamilton’sDistributors 3,500
Brena Wayland’s Boats 0
$19,000

INVENTORY as of December 31 ($76,000)

Kawasaki Ultra 250X Yamaha Waverunner FX Cruisers Snyder Craft 21
Nov. 1 $3,000 Oct. 1 $3,950 Oct.14 $16,000
Nov 18 $3,200 Nov 20 3,950
$6,200 Nov. 30 4,100
$12,000

Nanticoke Flyer Seahawk Miscellaneous Boat Supplies1
Aug 1 $1,950 No 15 $24,000 Various $13,800
Nov 3 $2,050
$4,000

1Cost will be given for each transaction associated with miscellaneous boat supplies.

TRANSACTIONS FOR THE MONTH OF JANUARY—Note that we will ignore Sales Tax for this project. Normally, one would have to provide an explanation for each general journal entry. However, since we are recording all entries in the general journal, explanations will not be necessary.

Jan 2 Issued a bond, face value $100,000, to Daniel Scheri’s Investment Company for $91,000 cash. Terms of the bond is 5 years and the stated interest rate is 9.6%. Interest and amortization will be recorded as an adjusting entry the end of the month.(See page 789 of text).

2 Issued 6,000 shares of common stock for $50,000. Remember that common stock is always recorded at par value.)

3 Sold a Yamaha Waverunner for $8,000 on account to Buena by the Shore,). Issued Invoice No. 719. (Note that we are using FIFO for inventory)

(Note that when making a sale using a perpetual inventory system, you always need two entries, one recognizing the sale, and one reducing inventory.)
Cash or/and Accounts Receivable XX
Sales XX
Cost of Goods Sold XX
Merchandise Inventory XX
3 Purchased a Snyder Craft for $16,800 on account from Szumowski’s’s Boats, Invoice No. 630, terms 3/10, n/60. Note that since we are using a perpetual inventory system, all purchases and sales need an entry in the account Merchandise Inventory.

4 Purchased various boat merchandise of $3,000 from Szumowski’s’s Boats on Account, Invoice No. 631, terms 3/10, n/60.

4 Issued Check No. 292 to Szumowski’s’s Boats in full settlement of our December account balance –Invoice No. 580, terms n/30.

4 Issued credit memorandum No. 75 to Parth Patel’s Boats for $1,000 for miscellaneous merchandise previously purchased. Our cost and value is 500. (Reverse the entry listed above on the 2nd but use Sales Returns and Allowance instead of the account Sales and the numbers given in this entry.)

4 Issued Check No. 293 to Copier Repair Co. for copier repairs, $500.

5 Received payment in full from Parth Patel’s Boats on sale made in December. (Do not forget the credit memorandum on the 4th.)

5 Sold a Seahawk to Evan Hughes Boats, for $36,000. We received $10,000 as a down payment. Issued Invoice No. 720.

5 Returned defective merchandise from the December 3rd purchase to Szumowski’s’s Boats and received a $500 credit memorandum. (Credit Merchandise Inventory—Boat Supplies)

6 Sold all the old warehouse storage equipment for $22,000. The warehouse equipment has a five-year life and a salvage value of $4,000. Assume the company uses the straight-line method to depreciate Warehouse Equipment. (Step 1—Bring the depreciation up to date by depreciating the warehouse for one month. Step 2—Remove the asset and accumulated depreciation and debit cash. Step 3—Plug to a realized gain or loss account– 701.)

7 Sold boat merchandise on account to Paige Connery Best Buys for $900, our cost $450. Invoice no. 720.

8 Issued Check No. 294 to Amanda Muetter’s Contractors to purchase a Building for $150,000. Straight-line method will be used over 20 years without any salvage value. At this time, you only will need to make the entry for the purchase of the building. (Note, that a month’s depreciation will have to be recorded as an adjusting entry at the end of the period.)

10 Issued Check No. 295 to the Internal Revenue Service in payment of FICA taxes accrued as of December 30 (FICA Taxes Payable— look at beginning trial balance for amount.)

10 Issued Check No. 296 to the Internal Revenue Service in payment of federal income taxes withheld as of December 30. (Employees’ Federal Income Taxes Payable—look at beginning trial balance for amount.)
.
10 Issued Check No. 297 to Kyj and Cheatem Investment Company for $3,000 of
equity marketable securities to hold excess cash. (This should be debited
to Investments–Available for Sale Securities –Account number 109.)

11 Issued Check No. 298 to Mathew Hamilton’s Distributors in full settlement of the December 30 purchase, Invoice No. 1002, terms n/20.

11 Issued Check No. 299 to Szumowski’s’s Boats in full settlement of our account for the two purchases early this month. (Recall the credit memorandum on the 5th.) (Note that when paying suppliers within a discount period, one must credit Merchandise Inventory.)

15 Check No. 300 voided. (No entry needed.)

15 Sold boat supplies on account to Parth Patel’s Boats , for $1,800 (Cost $900). Issued Invoice No. 721.

18 Received a check from Parth Patel’s Boats for balance of account.

19 Received full payment from Buena by the Shore on all the sales. To encourage prompt payment, we offered Buena a 2% cash discount.

20 Purchased on account from Brena Wayland’s Boats, two Yamaha Waverunners at $4,600 each (Total equals $9,200), Invoice No. 5900, terms n/30.

22 Sold a Yamaha Waverunner to Glassboro SeaWorld for $9,000) we received $5,000 as a down payment. Issued Invoice No. 722.

22 We are in a dispute with Paige Connery Best Buys about invoice number 720 on the 7th of this month. Since she has left the country for South America, it has been decided to write this account off using the allowance method. (Do not debit Bad Debt Expense.)

23 Issued Check No. 303 to Angelo Minniti’s Supply Co. for store and office supplies, $1,200.

23 One of the owners, Jenna-Rose Fraser , is unhappy with the direction the Corporation is going. YourName Corporation purchased her 200 shares of commons stock for $50 a share. Debit Treasury Stock.

24 Declared a $3.00 per share cash dividend. (Debit Retained Earnings and remember, one does not pay dividends on treasury stock.)

27 Sold a Yamaha Waverunner on account for $8,000 to Buena By Shore on account.

28 Purchased boat supplies on account from Mathew Hamilton’sDistributors , $1,500, Invoice No. 670, terms 2/10, n/60.

28 Purchased a Naticoke Flyer for $3,500 from Jonathan Horvat’ Boat Suppliers on account.

29 Sold boat merchandise on account to, Glassboro SeaWorld for $3,500 (Cost $1,800).

30 Issued Check No. 304 to the Galindo’s City Bank for the maturity value of the note payable. See beginning trial balance for terms of the note. (Interest was accrued on the note through December 31 in the account Interest Payable.)

30 Issued Check No. 305 to Pitman Electric Co. for December service, $550.

30 Issued Check No. 306 to the Rowan Whit for the month’s advertising, $400.

30 Issued Check No. 307 to Wenonah Telephone Co., $450.

30 Received partial payment of $10,000 from Evan Hughes Boats.

30 The payroll record for January is as follows:
debit credit
Sales Salaries Expense ………………………….. $4,500
Office Salaries Expense …………………………. 2,500
Total 7,000
Federal income taxes withheld ………………….. $1,400
FICA taxes withheld ……………………………. 500
Net Pay (Salaries payable) ……………… 5,100
Total 7,000

31 Record the employer’s FICA tax of $500 on the January payroll. (Debit Payroll Tax Expense and credit FICA Taxes Payable.)

31 Issued Checks Nos. 309-311 for the January Payroll. (Assume this is
one check.)

31 Issued Check No. 312 to pay the shareholders for the cash dividends declared on the 24th.

31 Total cash boat-supply sales for the month ended January 31 were $15,000 (Cost $6,500). To save time, we are recording this entry only one time. Normally this entry would be made every day the business is open.

31 Received cash dividends of $450 from investments (Credit Investment Income Account 703)

After completion of the journal entries, you may work in a team of two or three students. (I
highly recommend this for Finance majors.) Please submit only one copy for each team with each
team member as part of the name of the company . You may also use QuickBooks or any other
accounting program you are familiar with once you complete the journal entries manually.

There will be questions on the midterm, first quiz, and final that relate
directly to this practice set.

Assignment I—U.S. GAAP

2) Post to the general ledger. Take a trial balance of the general ledger and enter it on the worksheet. Prepare a schedule of accounts receivable and a schedule of accounts payable as of January 31. You must use Excel when doing the spreadsheet.

3) ADJUSTING ENTRIES
Complete the excel spreadsheet by using the following supplementary data. All of the account titles you will need in preparing the adjusting entries have already been included in the work-sheet in their proper numerical sequence.

a) Store and office supplies on hand as of January 31 are $1,600.

b) Insurance expense expired during the month was $200.

c) The balance in the Prepaid Rent account is for a 2-month period ending February 28. The company will be moving to new facilities by the end of February.

d) The Building will be depreciated over 20 years, using straight-line depreciation with no salvage value. The Office Equipment has an estimated life of five years with no salvage value.

e) Interest and amortization should be accrued on the bonds payable.
Note: the discount on bonds payable is amortized on the straight-
line method for the month of January.

f) YourName estimates that in the future approximately 3.0 percent of total accounts receivable will be uncollectible.Use the balance sheet method and adjust to this number.

g) The marketable securities have a market value of $15,400 as of Dec.
31 (Use accounts 801 and 109 for the unrealized gain/loss). Unrealized Gains/Losses is part of Owners’ Equity and is included as a part of Other Comprehensive Income and Accumulated Other Comprehensive Income in the Equity section of the balance sheet.

h) The corporate tax rate is 30%. Note that when computing income
tax for the corporation Unrealized Gains are not taxable.

4) Financial Statements due March 8th.
Prepare the following statements listed below and submit them in this order. Since you only have information about the post-closing trial balance, you can only do one month’s worth of financial statements.

1. Statement of Net Income—See below for EPS information.

2. Statement of Comprehensive Income (This can be completed in one of two ways. Thus, it may not be the third item.)

3. Statement of Financial Position (Balance Sheet) (FOR THIS SHOW CALCULATIONS)

4. Statement of Changes of Owners’ Equity—Note that the Statement of Retained Earnings is part of the Statement of Changes of owners’ Equity. (FOR THIS SHOW CALCULATIONS)

5. Minimum of one page of Footnotes and Disclosures.

Footnotes (Minimum of one page single spaced except between individual footnotes.) See appendix 5B to book’s companion website for examples. Also search the net, and USE YOUR IMAGINATION!

6. One page devoted for ratios. (Show work.) For ratios e and f please use the beginning and ending month balances. Normally, one would use the beginning and ending of the year balances.

a. Working Capital (See page 209 for formulas)
b. Current Ratio
c. Acid-test Ratio
d. Profit Margin on Sales (FOR THESE SHOW CALCULATIONS)
e. Receivables Turnover Ratio1
f. Inventory Turnover Ratio1

If you are completing these statements as part of a group, please list your name as one of the CPAs on the title page.

You do not have to divide operating expenses into selling expenses and administrative expenses on the income statement and may use schedules to keep the statements simple. Please use a multiple-step income statement format for the income statement (See notes) and a classified balance sheet.

When computing earnings per share, take into consideration the entries on 1st and the 29th; however, you do not have to do a weighted average. To keep the computation simple, just use the number of shares outstanding the last day of the month.

All financial statements must be completed using a spreadsheet word processor.

5) Journalize and post all adjusting and closing entries. (USE EXCEL)

Assignment II—IFRS Requiremen: (NO NEED FOR THIS TO BE DONE)

Describe how IFRS financial statements would be different for YourName boating if she used IFRS. Please make a list of these differences.

Assume the following information for preparing the financial statements using Proposed International Financial Reporting Standards.

1. The fair value of the building has increased to $175,000
2. The fair value of the office equipment is $17,000.
3. Because of the economy, the fair value of the inventory is $3,000 less than the cost.

Complete the financial statements using the proposed parallel classification scheme of the financial statements. You do not have to include footnotes since you already completed them for the U.S. GAAP statements. (Note that comprehensive income can only be displayed in two forms.)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

BERKSHIRE HATHAWAY INC.

Accounting
Paper, Order, or Assignment Requirements

BERKSHIRE HATHAWAY INC. Company to be used

The essay should demonstrate a student’s ability to integrate and synthesize course concepts with selected readings to communicate his/her understanding of financial management concepts their application in organizations. The essay should also demonstrate a student’s ability to communicate as a manager. This includes proper writing style, organization, grammar, and spelling, as well as integration of course-related material. The writing style must follow the Publication Manual of the American Psychological Association , 5 th edition. Citations for online sources should include the online address (URL) and access date as well as the citation for the specific reference.

Research for the paper may be conducted online using the UMUC online library as the primary source. Do not use abstracts, use full-text articles. Publications that may be relevant for the topics listed below include: Strategic Finance, The Journal of Business Finance and Accounting, CFO Magazine, Nonprofit World, Harvard Business Review, or other accounting and financial journals.

The paper should:

Be based on your reading and research relevant to the topic.
Needs to have appendices, exhibits, and references.
Include a one-page Executive Summary immediately following the title page that includes a statement of the major issue(s) and your conclusions and specific recommendations. The content of an Executive Summary is similar to an abstract.
Properly cite reference sources: these may include course material, information from magazines, journals, and online sources. All reference sources must have a publication date within the last fifteen years. Students who wish to use an older source publication should contact the instructor with the request and reason.
Essay Topic

Ratio and Financial Statement Analysis – Your essay should critically analyze the benefits and limitations of ratio analysis, explaining what factors impact the meaningfulness of such measures and what new practices or theories may be emerging regarding the application of ratio and financial statement analysis. Emphasize practical applications and real-world use of ratios synthesizing your readings in published research or survey articles (Relevant Text Material: Parrino – Chapters 3 & 4). please use this chapters if you can find them let me know I think I can download them and provide them to you

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Corporate Finance and Financial Accounting Coursework

Corporate Finance and Financial Accounting Coursework
Paper, Order, or Assignment Requirements

Chosen Company: Ocado

Step 1 of Coursework
Now that you have chosen your target company and completed Lecture 1, as well as the tutorial for the lecture, you can start your coursework.
The first method that we will use in the valuation of our target company is called Valuation Multiples (or method of comparables or “comps”). An example of this method is the price earnings ratio. You may want to refer to the chapter in the recommended textbook on Valuing Stocks.
In line with the above, you will now need to choose benchmark companies in the same industry as your target company. These may be UK or foreign companies. For example, if I was valuing Royal Mails Plc I would probably use Deutsche Post (of Germany) as one of my benchmarks as I do not have a closely similar company listed on the London Stock Exchange. While you may decide to use all firms in the industry, it is acceptable to restrict the number of benchmarks to three. In extreme cases, a single benchmark may also be used. Note that I do not need to approve your choice of benchmarks. I will mark this in your report.
For all the companies (your target company and its benchmarks) you will need to calculate and discuss the following ratios:
• Price-earnings ratio price per share/ earnings per share
• Enterprise Value to Sales ratio
• Enterprise Value go EBITDA ratio
• EBITDA to Sales ratio

Step 2 of Coursework
Now that you have an idea of the value of your target company, by completing Step 1 of your coursework, our objective in Step 2 is to understand the company and its environment better. The purpose of this knowledge is to be able to improve and justify the valuation of the company.
Therefore, in Step 2, you will need to do a SWOT analysis (Strength, weakness, opportunities and threats) of the company. Issues that you may want to cover include:
• The companies market position (relative to its competitors)
• Business Model (how sound is it?)
• An assessment of the company’s sources of inputs and finance
• Risk management systems/corporate governance mechanisms in place (you may want to compare this with the requirements for listed companies on the London Stock Exchange, available on the Exchange’s website)
• Financial Performance (look at the liquidity/working capital position, profitability, gearing etc. What can you improve to generate synergy?
• Expansion potential
• Strong franchise value- this is the best source of growth. Does your target company have one it’s probably not maximising?
• Management team- poor management team is generally a motivation for takeover. There are ratios to calculate management efficiency.
You may want to discuss the above in about 1000-1500 words.
Other issues
Some of you have asked me if you need to show the formulas for your calculations. I need the figures used but not the formulas. You may want to send all formulas to the appendix (in which case I may not read them). Also, if you have used a spread sheet to complete your coursework, you may want to include this when submitting.
In addition, students have raised the question regarding the interpretation of derived figures. You will need to read materials on ratio analysis, a topic I believed you should have taken. You may also consult the relevant chapters of BD textbook.

Step 3 of Coursework
This step of your coursework carries 50% of the total marks (i.e. 50% of the 30% allocated to the coursework).
In this step you are required to come up with a business plan for your target company as well as a valuation of the company. In coming up with a business plan you should look at the operations, investments and capital structure of your target company with the aim of assessing any potential improvements and future growth. This plan must project the post-acquisition synergies – assume that these would be captured by the target company as you are not required to combine the financials of both the acquirer and the target in the coursework.
You will be coming up with a number of reasonable assumptions at this stage. These assumptions should be justified on the bases of past performance and position of the target company (strength and weaknesses of the income statements and the balance sheet).
In line with the BD textbook (Chapter 19- Valuation and Financial Modelling), please provide necessary calculations regarding operational improvements, capital expenditure and capital structure. You will then need to build a financial model of free cash flow. You need not forecast the balance sheet or the cash flow statement. You may also want to skip improvements in working capital management, as we have not treated this topic- the value of “increase in working capital” would be zero in this case.

It is important to note that your forecast of free cash flow should include two parts:
• Forecast over the short-term horizon (Year 1-5, where Year 0 is assumed to be 2014, the year for which the latest financial data is available) (5 Marks).
• The terminal value – assume that free cash flow at the end of Year 5 (2019) will grow at a constant from Year 6 (2020) to infinity (5 Marks).
• You will need to justify forecast of cash flows for the short horizon and the growth rate for the long horizon that you chose (5 Marks). Therefore, even though your Year 0 is 2014 you will need the accounting data for year -1 to say -5 (that is 2009-2013, 2009). You need not present the data for Years -1 to -5 in your report.
To be able to get the value of the target company, discount the free cash flows at the company’s cost of capital. You should derive the cost of debt (4 Marks) and the cost of equity (2 Marks). Please derive the cost of equity using CAPM. You can then use your results to calculate the weighted average cost of capital (4 Marks). To apply the CAPM you can take the easy path and simply use the beta value you have sourced (e.g. from Bloomberg or Financial Times). However, if you are able to run a regression to derive this value yourself and signal to me that you did this, I will credit you accordingly (4 Marks). You will need to source the risk free rate (use the yield UK Treasury Bond and justify). In line with empirical evidence and practice, please assume that the market risk premium is 5%. Calculate the cost of debt as interest payment divided by long-term debt (i.e. do not include short-term capital in your calculation). You can get the corporate tax rates in the UK by following this link: http://www.hmrc.gov.uk/rates/corp.htm.

It is important that you pay attention to the terminal value as it accounts for a significant proportion of the value of the company. To recount what I said in class, to get the terminal value at the end of Year 5 (which is the beginning of Year 6) use the formula for the present value of growing perpetuity. However, because we need the present value in Year 0, you will then need to discount back to Year 0, where “n” in your discounting formula equals 5 (5 Marks).
Therefore, the value of the target at Year 0 is the addition of the present value of cash flows (Year 1-5) and the present value of the terminal value. Assuming the firm has existing debt (before any new that you will introduce) you then need to subtract this from the value of the firm that you calculated to arrive at the value of equity. If you divide this by the number of shares in issue, you will get the intrinsic value per share based on the discounted cash flow method (5 Marks). Remember that we are evaluating the value of a company (its equity) and not a project. So you are not calculating the NPV. If you are, what is your initial investment? Many good students have made this mistake in the past.
Remember the value of equity you established in the Step 1? We need it in Step 3. To arrive at a value of the equity, we will need to find the weighted average of the value from Step 1 and the value from Step 3. In practice, we normally attach a greater weight to the value derived using the discounted cash flow method (Step 3). There are no hard rules about what weights you should allocate to the values. Just demonstrate to me that you know that the DCF method is significantly more important than the method of comparables. (4 Marks)
You can now compare your final value of the equity with what the market says (i.e. market price per share). Is your company undervalued? That is market price per share is lower than your calculated value of the company- a good justification to recommend a takeover (3 Marks).
Please allocate between 1000 words to the discussion of this part of your coursework (4 Marks). You may want to transfer all tables and calculations to the appendix section of your work.
Our final step will be the structure that I will require when presenting your report.

Please follow the guideline below in presenting your coursework report. (10marks)

1.1. Executive Summary
2.1. Review of UK and Global Economy (Re: Step 2 of Coursework)
2.2. Review of Target Company Sector (Re: Step 2 of Coursework)
2.3. Company Information (Re: Step 2 of Coursework)
3.1 Preliminary Valuation: Assumptions, Results, and Discussion (Re: Step 1 of Coursework)
3.2 Valuation: Assumptions, Results, and Discussion (Re: Step 3 of Coursework)
3.3 Sensitivity Analysis (Optional)
4.1 Recommendations and Conclusion
• Buy?
• At what price?
o e.g. average of results using the various valuation methods
o remember this is not an NPV coursework
• Any other issues
o e.g. limitations of your method

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Conduct correlation analysis on ROE, P/E and P/B ratios.

Finance and Accounting
Paper, Order, or Assignment Requirements

One of the learning outcomes assigned to Intermediate Accounting II (ACCT222), is the ability to utilize information technology in making business decisions. To assess this outcome, you will be expected to participate in the following activities:
1. Data gathering
2. Data processing
3. Reporting information
Data gathering:
You will be assigned a company listed on the Qatar Stock Exchange which is ((Al Meera Consumer Goods Company)). You will need to go on to the following website in order to download in information about your company's quarterly financial statements and financial ratios for the period March 31, 2011 until December 31, 2015 (total of 20 reports):
http://www.qe.com.qa/pps/qe/qe%20english%20portal/Pages/Home/
* To find quarterly financial statements, go to the listed Securities tab in the Qatar Exchange website, and then click financial statements. From the reports, you will need to collect information about the companys net profit and total shareholders equity.
* To obtain financial ratios, go to Market Statistics and then Financial Indicators. Select the date, starting with March 31, 2011, then June 30, 2011 and so forth. The two ratios that you will need are P/E ratio (defined as stock price divided by the earnings per share) and P/B ratio (defined as stock price divided by the book value per share).

Data processing:
* Input and organize the data into an excel spreadsheet. You need to have separate columns for the date and each variable (i.e. net income, shareholders equity, P/E ratio and P/B ratio).
* Compute your companys return on equity (ROE) ratio using the formula functions.
* Make sure that your Microsoft Excel has data analysis in the Data tab. If it does not, then please follow the instructions shown in the video through the link below:

* Conduct correlation analysis on ROE, P/E and P/B ratios. For more information on doing correlations via Excel, please follow the video in the link below:

* Conduct regression analysis where ROE is the dependent variable and P/E and P/B ratios are the independent variables. For more information on doing regression via Excel, please follow the video in the link below:

Reporting information:
Write a brief report (two pages maximum) about the results of the correlation and regression analyses. Please make sure that you hand in the project in PDF form.

If you need help analyzing regression results, then please refer to the link below (minute 2.00).

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Accounting outsourcing business in Saudi Arabia for small companies

Accounting outsourcing business in Saudi Arabia for small companies
Paper, Order, or Assignment Requirements

Important points should be conceder before write the assignment if you cannot follow the instructions below don’t write the assignment.

My business name is Trial Balance Solutions company. It is accounting outsourcing business in Saudi Arabia for small companies, it will own by Osama, has got bachelor of accounting, CPA and master of finance and me Ahmed, bachelor of accounting and MBA. We will employ 3 accountants and 2 under graduate students from an accounting college (part time).
Statistics:
o Total accounting offices in Saudi Arabia is 153 offices.

o The companies total are 900,000 companies by the end of 2010.

o 5734 companies are new companies in 2010.

o It was difficult for me to market size study in Saudi. However I’ve got market size study in Dubai, which you can use it as similar market like Saudi. You should mention that in the assignment.

I need you to create a business canvas in appendix.
In fist stage within 2 years: the firm will provide accurate recordings of transactions (book keeping) coupled with proper assessment and processing for small business clients. The secondary streams of revenue can come from small Tax preparation services and the Company can sell advertisement space and products placement for companies that are looking forward to connecting with the demographic that the firm has.
Second stage after 2 years: the firm owners will work with software programmer to designed and create their own accounting software. it will offer own accounting software designed to assist small companies and medium save time so you can focus on growing their business. All companies data is saved securely online, which they can access their information and participate with their colleagues and accountant anywhere, any time.
Services

Stage 1

Trial Balance Solutions Company will offer the following bookkeeping services by using accounting software such as Quickbooks or Xero:

Payroll processing
Accounts payable (entry, bill paying)
Accounts receivable (entry, invoicing, deposits, collection)
Bank reconciliations.
Inventory management.
Financial statement preparation.
Other financial reporting.
To provide a full suite of tax and management accounting services for small businesses, allowing business owners to not only save money over in-house accounting and ensure their compliance with tax laws, but to make valuable management decisions from their numbers and use my partner certificate CPA which gives him the authority to sing on tax report:

Tax preparation.
Tax planning.
Addressing zakat problems.
Stage 2

Accounting software service after 2 years will design own software then will offer our customers to use our system:

Bookkeeping.
Reports.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Provide a brief discussion of what is meant by the term “corporate governance”.

Accounting
Paper, Order, or Assignment Requirements

This assignment comprises THREE (3) questions.

This Assignment is designed to give you an opportunity:

demonstrate applied knowledge of the accounting regulatory environment and the accounting and finance processes, systems, concepts and techniques used globally in business practice
appreciate ethical frameworks and codes of practice and their application to accounting and finance outcomes to help comprehend and address complex ethical dilemmas
This assignment comprises THREE (3) questions.

Question 1: (25 Marks)

Provide a brief discussion of what is meant by the term “corporate governance”. Include in your discussion the various regulatory influences on public companies in Australia in relation to corporate governance. Also provide your opinion whether Santos exercises good corporate governance and list possible strengths (3) and weakness (3) of corporate governance at Santos Ltd with clear reasons as to why you have identified them. (10 Marks)
What is Triple Bottom Line Accounting? What indications or examples can you find in the reports to indicate that Santos is delivering in terms of the Triple Bottom Line. Give at least two examples for each. (8 Marks)
In your opinion how is the company performing? How do you justify this assessment of performance? What external factors might impact the performance of this company. (Note 5 clear explanations should be given) (7 Marks)
(maximum number of words: 700-800)

Question 2: (60 marks)

Founded in 2010, Instagram considers itself to be “a fun and quirky way to share your life with friends through a series of pictures.” By downloading the free Instagram mobile application (or app), users snap a photo with their mobile phone, then choose a filter to transform the image, and can share it on various sites such as Facebook and Twitter. The company views itself as more than just a photo-storage tool but a way “to experience moments in your friends’ lives through pictures as they happen. We imagine a world more connected through photos.”

In April 2012, the 13-employee company was acquired by social networking giant Facebook for approximately $1 billion. In less than three years, Instagram has become one of the fastest growing social media platforms as seen by its estimated 12 million daily users

In December 2012, several months after being acquired by Facebook, Instagram announced new changes to its privacy policy and terms of use. According to the updated terms, “a business or other entity may pay Instagram to display users’ photos and other details in connection with paid or sponsored content or promotions, without any compensation to you,” and there was no apparent option to opt out. The backlash was immediate. Photographers and celebrities were particularly upset, given that their photos were a part of their own businesses and brand images.

Instagram was quick to respond that its intention was simply to improve advertising. Co-founder Kevin Systrom posted, “Our intention in updating the terms was to communicate that we’d like to experiment with innovative advertising that feels appropriate on Instagram. Instead it was interpreted by many that we were going to sell your photos to others without any compensation. This is not true and it is our mistake that this language is confusing. To be clear: it is not our intention to sell your photos.”

Instagram’s privacy policies and terms of use were once again updated in January 2013. The current terms state, “You hereby grant to Instagram a non-exclusive, fully paid and royalty-free, transferable, sub-licensable, worldwide license to use the Content that you post.” Instagram also reserves the right to share users information (including analytics information, log files, cookies, and location data, as well as the content users post) with companies affiliated with Instagram (mainly Facebook), third-party service providers, third-party advertisers, and “other parties.”

While the initial backlash against Instagram has been quelled, there is still uneasiness among users regarding privacy issues. Instagram has to walk a fine line to keep its users happy and still turn a profit. On one hand, Instagram offers a free service to users, which up until this point has been free of advertisements, unlike other social media platforms like Facebook. In order to remain a viable company, Instagram has to bring in revenue somehow, and advertising seems the obvious choice.

Required:

Relying on two ethical theories, discuss how Instagram failed to comply with these theories in deciding to change its terms of service.

(maximum number of words: 1500-1600)

Question 3: (15 marks)

In each of the following situations, identify whether the item should be included in the balance sheet of Transom Trading as at 31 December 20×1, and, if so, at what amount and under which heading. Transom Trading is retailer of motor parts and accessories. In all cases, brief reasons for your decision must be given (Note that you are not required to prepare the accounting transaction).

A freehold shop was bought in August 20×1 for $176,000. A mortgage of $60,000 was taken out to buy the shop in August 20×1 and the balance paid in cash
Goods on the shelves at the end of the day of 31 December 20×1 have a resale value of $24,000 and were purchased by Transom for $16,000
iii. A delivery van, costing $12,000, which Transom ordered on 20 December 20×1 was delivered and paid for by cash on 12 January 20×2.

Shop fittings worth $6,000 were bought at an auction by Transom for only $3,000 cash prior to opening the shop in August 20×1
A Ford Falcon costing $7,000 was bought by the owner of Transom through the business in November 20×1 for his wife’s use. He did this because the Ford Falcon he had bought privately second hand in September for $8,000 was being used exclusively for collecting and delivering goods for Transom and not as a family car, as originally intended
One cash register was rented from Equipment Supplies at an annual rental of $400
vii. One cash register was bought by Transom in November 20×1 for $1,200

viii. A bank overdraft was drawn down to $13,000 on 31 December 20×1

Seat belts which the owner of Transom bought for $12,000 in September from a market trader in good faith were subsequently found to be defective and worthless
Staff wages of $1300 were paid with PAYG tax equally $120

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Discuss the uses & limitations of CVP analysis and its effects on management decision making, planning and controlling activities and making business decisions.

Discuss the uses & limitations of CVP analysis and its effects on management decision making, planning and controlling activities and making business decisions.
Paper, Order, or Assignment Requirements

Please 550 words (excluding the title, headings/sub-headings and references)

Some useful journals to search include (various other journals may also be useful):
1. Accounting Horizons
2. Harvard Business Review
3. Journal of Cost Management
4. Journal of Management Accounting Research
5. Management Accounting Research
6. Management Accounting (UK)
7. Strategic Finance
8. Australian Accounting Review
9. Accounting and Finance
10. Australian Accounting Review

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Using the traditional approach to accounting for overheads, calculate the product cost per unit for each of the three products.

Accounting
Paper, Order, or Assignment Requirements

Managerial Finance Assignment 1 AC50030E Background Roman Ltd. Manufactures three different products and the following information is available concerning these products together with other operating statistics and information. The company calculates selling price as a mark- up on cost of 10%. The company has total overheads of RWF 748, 800, which are currently allocated on a plant-wide basis using direct labour hours as the absorption base. Roman Ltd is considering implementing on Activity Based Costing (ABC) system and has recently identified various cost drivers and assigned costs to related activity cost pools as follows:- Managerial Finance Assignment 1 AC50030E Required:

(1) Answer the following:

A) Using the traditional approach to accounting for overheads, calculate the product cost per unit for each of the three products. (10 Marks)
B) Using the principles of Activity Based Costing, calculate the product cost per unit for each of the three products. (20 Marks)
C) Explain the difference in your answers to (a) and (b) and the potential implications for decision making in Roman Ltd. (10 Marks) (Total: 40 marks)
(2) It is just as important for an organisation to determine how individual customers or groups of customers differ in terms of the profitability to the organisation as it is to determine the relative profitability of products. Briefly explain how this can be done. Would you advise Roman to do this? (Total: 15 Marks)

(3) Keita is a client of your firm and operates a small courier service on the east region of Canada. She is keen to expand the business in the future and has just attended a seminar on the usefulness of management accounting in small companies. She is aware that management accounting is common in manufacturing industries but is unsure of its relevance to service industries such as her own courier company. Managerial Finance Assignment 1 AC50030E Keita has asked you to write a report addressing her concerns as follows:

(i) Explain the role of management accounting in a modern business environment. (10 Marks)

(ii) Outline two areas of difference between management accounting and financial accounting (10 Marks)

(iii) Explain how and why management accounting may be applied in service industries. (10 Marks)

(iv) Advise Ketia on one specific use of ABC approach, which will be beneficial in the future, expansion of her business. (10 Marks) (Total: 40 Marks) Report format and bibliography. Marks will be awarded for structure and presentation. (This includes the appropriate use of appendices, clarity of explanation and ability to summarise your findings). (Total: 5 Marks) (TOTAL :100 MARKS)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"