A food manufacturing company needs a data mart to summarize facts about orders to move goods. Some orders transfer goods internally, some are purchases from vendors, and some are returns of goods from customers. The company needs to treat customers, vendors, plants, and storage locations as distinct dimensions that can be involved at both ends of a movement event. For each type of destination or origin, the company wants to know the type of location (i.e. customer, vendor, etc.) name, city, and state. Facts about each movement include dollar volume moved, cost of movement, and revenue collected from the move (if any, and this can be negative for a return). Design a star-type schema to represent this data mart. Hint- after you design a typical star schema, think about how you might simplify the design through the use of generalization.

All ratios should use year-end totals and not averages and be compared to its industry average as well as time trend analysis. Calculate the ratios mentioned in the table below. For the turnover in days, assume 365 days. Also the debt ratio industry average given in the case is actually the liabilities-to-asset ratio. Hint: for Cash flow statement, you have to add back amortization to the Land, Plant, and Equipment item.

Ratios:

Income Statement

2005 2006 2007 2008 2009

BALANCE SHEETS

SALES ANALYSIS

2. On December 31,2015 the Waddell Corporation acquired a custom-made plant asset by issuing a promissory note with a face value of $800,000, a due date of December 31,2022, and a stated coupon rate of interest 4%.

More Information: Interest is compounded annually and is payable at the end on each year. The fair value of the customized asset is not readily determinable and the note receivable is not publicly traded. Given the​ company's incremental borrowing rate and current market​ conditions, the imputed rate of interest for the note is estimated as 9%.

Record the journal entry for the purchase of the plant asset.

I have this so far.

6. Einhorn Devices acquires Howard, a small start-up company, by paying $2,170,600 in cash on January 2. Below are teh book values and fair values of Howard on the date of acquisition.

a. What is amount of goodwill required?

b. what intangible assets are required? which of the intanibles have an indefinite life? Which will be amoritized? What will the amortization expense in the year after acquisition?

Analysis and Interpretation of Liquidity and Solvency Headquartered in Calgary, Alberta, Husky Energy Inc. is a publicly traded, integrated energy company. Selected fiscal year balance sheet and income statement information for Husky Energy follow (Canadian $ millions). C$ millions 2018 2017 Cash and equivalents $2,895 $2,538 Short-term investments - - Accounts receivable 1,369 1,369 Current assets 5,745 5,672 Current liabilities 4,994 3,507 Total liabilities 15,611 14,960 Total equity 19,810 18,147 Earnings before interest and tax (EBIT) 2,116 731 Interest expense, gross 314 392 Required a. Compute the current ratio and quick ratio for 2018 and 2017. Note: Round your answers to two decimal places (for example, enter 6.78 for 6.77555). 2018 2017 Current ratio Answer 0 Answer 0 Quick ratio Answer 0 Answer 0 b. Compute times interest earned and liabilities‑to‑equity ratios for 2018 and 2017. Note: Round your answers to two decimal places (for example, enter 6.78 for 6.77555). 2018 2017 Time interest earned Answer 0 Answer 0 Liabilities-to-equity Answer 0 Answer 0 c. Husky's liquidity is best described as Answer Husky's solvency is best described as Answer

These are a list of the transactions I have from playing Monopoly. I need to create a balance sheet, income statement, and cash flow.

STOCK- Issued $1500 common stock

LAND/STOCK- $600 issued for purchase of Land

1 RENT REVENUE- $16.00 From New York Ave

2 CONSULTING REV(ACCTS REC.) - Collected $200 for passing Go

3 LAND - Purchase Kentucky Ave $220.00

4 RENT EXPENSE - $200.00 for landing on Railroad

5 CONSULTING REV(ACCTS REC.) - Collected $200 for passing Go

6 DIVIDENDS - Paid $200 to bank for landing on Income Tax

7 RENT REVENUE - $2.00 from Mediterranean Ave.

8 UTILITIES - Purchase Electric Company $150.00

9 INVESTMENT INCOME - Earned $20.00 from Electric Company

10 RENT EXPENSE - $26.00 for landing on Pacific Ave.

11 RENT REVENUE - $16.00 from New York Ave.

12 DIVIDENDS - Paid $75.00 for Luxury Tax

13 CONSULTING REVENUE - $200.00 For Passing Go

14 LAND - Purchased Oriental Ave. for $100.00

15 RENT REVENUE - Movie Company to use property as set, collected $200.00

16 LAND - Purchased Atlantic Ave. for $200.00

17 LAND - Purchased Indiana Ave. for $200.00

18 BUILDINGS - Purchased a house for Kentucky Ave. For $150.00 19 DIVIDENDS - Paid $75.00 for Luxury Tax

20 CONSULTING REVENUE - $200.00 For Passing Go

21 TRAVEL EXPENSE - Paid $100 for landing on Pacific Railroad

22 RENT REVENUE - $40 from Illinois Ave.

23 BUILDINGS - Purchased a house for Indiana Ave. For $150.00

24 RENT EXPENSE - Paid $12.00 from landing on Virginia Ave.

25 RENT EXPENSE - Paid $14.00 for landing on St. James Place

26 RENT REVENUE - Earned $10 from States Ave.

27 RENT EXPENSE - Paid $56.00 for landing on Pennsylvania Ave.

28 RENT REVENUE - Earned $90 from Kentucky Ave.

29 CONSULTING REVENUE - $200.00 For Passing Go

30 TRAVEL EXPENSE - Paid $100 for landing on Pacific Railroad

31 RENT REVENUE - Earned $90.00 from Indiana Ave.

32 RENT EXPENSE - Paid $56.00 for landing on Pennsylvania Ave.

33 DIVIDENDS - Paid $75.00 for Luxury Tax

34 FINE EXP - Paid $50.00 Fee to get out of Jail

The company has the following account balances on June 1, 2020. (all accounts have their ‘normal’ balances)

Drawings: 1000

Cash: 20000

Service revenue: 50000

Capital: 15000

Depreciation Expense: 700

Equipment: 30000

Accounts Payable: 5000

Insurance Expense: 500

Unearned Service Revenue: 4000

Prepaid Service Revenue: 500

Accounts Receivable: 4000

Rent Expense: 5000

Salaries Expense: 16000

Accumulated Depreciation - Equipment: 3000

During June 2018, the following events took place. Where appropriate, record a journal entry for each transaction. If no journal entry is required, write ‘no entry’.

1. On June 2, the company prepaid rent for July to September for $6,000.
2. On June 8, someone invested $3,000 cash and a computer system valued at $2,000 into the company.
3. On June 10, the company collected $4,000 it was owed on account.
4. On June 15, The company provided a quotation for membership fees to a corporation looking to provide fitness benefits to its employees. The quotation was for $10,000. The corporation will decide next month if it is a good fit.
5. On June 22 the company provided product and collected $5,000.
6. On June 24 the company received a $1,000 bill for advertising expense that it will pay in the near future.
7. On June 27 the company paid $2,000 cash on account.
8. On June 29, the owner withdrew $600 for personal use.
9. On June 30, the company purchased $1,000 of supplies on account.
10. On June 30, the company paid employee salaries of $3,000.

Prepare the unadjusted trial balance for the company at June 31, 2018.

Sheridan Company’s balance sheet at December 31, 2016, is presented below.

During January 2016, the following transactions occurred. Sheridan Company uses the perpetual inventory method.

- Prepare an adjusted trial balance at January 31, 2017. (Round answers to 0 decimal places, e.g. 1,250.)

- Prepare an income statement.

- Prepare a balance sheet as of January 31, 2017

THANK YOU!

Please solve this case in Excel，Many thanks!

The Problem:

You are the technology controller for a mid-sized publicly traded company. You have been assigned to evaluate an investment in a new process that would cost $2.5 million. You have determined that the internal rate of return of the positive operating cash flows associated with the investment is 13.0%.

On a market value basis, the firm's capital structure is as follows:

Debt: 40%; Preferred Stock: 5%; Common equity: 55%;

This capital structure is in line with the peer group industry average, and management has no appetite for altering the existing ratios, which they consider to be optimal.

Your firm’s current stock prices are $95 per share for common equity and $60 per share for 9% $100 par value cumulative preferred stock. The 2018 common dividend was $10 per share, and the company has increased this dividend by 5% per year for the past ten years. The company also has $1,000 par value 10% coupon bonds outstanding, with a remaining maturity of ten years. The bonds are currently trading at 87.5% of par value. The capital markets are very receptive to the company's bonds and preferred common equity, all of which are actively traded both regionally and nationally.

In addition to this, you determine that the 20-year average yield on 10-year US Treasury obligations is 5% and that the market risk premium is 7%. Your firm's common equity has been given a beta of 1.65. The firm's effective rate of income tax is 25%.

In organizing financing for the proposed project, you have approached your firm's bank. The bank has agreed to a limited amount of long-term secured financing to a maximum of $ 600,000, at 6%. The bank would be willing to supply an additional $ 400,000 of long-term funds on an unsecured basis, at a rate of 15%, as an alternative to a bond issue. Based upon the company's conservative retention policy and healthy cash reserves, you are confident that it could fund up to $1.5 million of the proposed investment with internally generated retained earnings.

Based upon the information provided above, come up with a funding plan for the proposed investment and make a recommendation as to its suitability from a financial standpoint.

On January 1, 2004, Bentham Company sells office furniture for $60,000 cash. The office furniture orginally cost $150,000 when purchased on January 1, 1997. Depreciation is recorded by the straight-line method over 10 years with a salvage value of $15,000. What gain or loss on sale should be recorded on this asset in 2004?

Bruno Company purchased equipment on January 1, 2009 at a total invoice cost of $280,000; additional costs of $5,000 for freight and $25,000 for installation were incurred. The equipment has an estimated salvage value of $10,000 and an estimated useful life of five years. The amount of accumulated depreciation at December 31, 2010 if the straight-line method of depreciation is used is:

Equipment with an invoice cost of $20,000 was placed in service on January 3, 2009. Installation costs of $8,000 were added to Repairs Expense. These cost should have been added to the Equipment account. Depreciation for 2009 was computed using the straight-line method, and an estimated useful life of five years, with no salvage value expected. The net income reported for 2009 was:

Based on the 1960–2005 period, if a Canadian company were to import from Brazil and must pay in Brazilian reias when the goods are delivered in 90 days, should the company get the currency through the spot or the futures market? Why? Would it be different if the company had to pay in US$? Explain.

Especially, this part "Would it be different if the company had to pay in US$? ", please explain in detail. thanks