All your analyses will be done using operating income (not net income after taxes) so you can ignore income taxes.

Assume you work as a staff member in a large accounting department for a multinational public company. Typically, you handle equipment purchases costing $50,000 or less. The CFO states that he and the CEO have negotiated significant new arrangements with the company's equipment suppliers, which require the company to make advance payments for equipment to be purchased in the future. The CFO says that, for various reasons that he did not want to discuss, he will be processing the payments through the operating division of the company rather than the equipment accounting group. Given that the payments will be made through the operating division, they will initially be classified as operating expenses of the company. He indicates that clearly these advance payments for property and equipment should be recorded as assets, so he will be contacting you at the end of every quarter to make an adjusting journal entry to capitalize the amounts inappropriately classified as operating expenses. He advises you that a new account, called Prepaid Equipment, has been established for this purpose. He quickly wraps up the meeting by telling you that it is important that you do not talk about the special project with anyone. You assume he does not want others to become jealous of your new important responsibility. A few weeks later, at the end of the first quarter, you receive a voicemail from the CFO stating, The adjustment that we discussed is $850,000,000 for this quarter. Your company generates over $8 billion in revenues and incurs ~$8 billion in operating expenses every quarter, but you have never made a journal entry for that much money. You quietly make the adjusting journal entry. For each of the remaining three quarters in that year and for the first quarter (Q1, Year 1) in the following year, you continue to make these end-of-quarter adjustments. The magic number, as the CFO liked to call it, was $660,000,000 for the second quarter (Q2, Year 1), $845,000,000 for the third quarter (Q3 Year 1), $991,000,000 for the fourth quarter (Q4 Year 1), and $910,000,000 for first quarter of the following year (Q1 Year 2). Typically, whenever an ordinary equipment purchase involves an advance payment, the purchase is completed a few weeks later. At that time, the amount of the advance is removed from an Equipment Deposit account and transferred to the appropriate equipment account. This has not been the case with the CFO's special project. Instead, the Prepaid Equipment account has continued to grow, now standing at over $3.8 billion.

Required (dollars are in millions):

1. Complete the blank cells in the first table in the Excel document on D2L to determine what the company's accounting records look like after you made the journal entries as part of the CFO's special project. Note that when you made the journal entry, the Property and Equipment, Net account accumulated the magic numbers each quarter. For example, in Q1 Year 1 the entry to Property and Equipment, Net account results in a balance of $48,000 plus $850 or $48,850. In Q2 Year 1 the amount would be $46,000 plus $850 from the prior quarter plus another $660 for the current quarter or $47,510 and so on. Included in your workbook spreadsheet (row 3) are the adjustment amounts for each of the 5 quarters so you can refer to those cells when doing your calculations. Also note the operating expenses will be reduced each period by the amount capitalized in that period. For example, in Q1 Year 1 operating expenses would be reduced by $850 and in Q2 Year 1 operating expenses would be reduced by $660. Sales revenue should not be altered by the journal entry.

2. Complete the second table in the Excel document on D2L using both before and after the magic entry numbers. You will need to compute the fixed asset turnover ratio (rounded to three decimal places) for the periods ended Q2Q4 of year 1 and Q1 of year 2. Note you cannot answer this for Q1 of Year 1 because you dont have beginning Property and Equipment, Net. For these same 4 quarters also calculate the net profit margin before and after the magic entry. Discuss in 2-4 sentences in a text box what you notice about the two ratios. You must use the power of Excel in computing your ratios to get a 10 on this assignment.