Question

In: Accounting

Krall Company recently had a computer malfunction and lost a portion of its accounting records. The...

Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations.

Required:
Help Krall rebuild its information database by completing the following table: (Do not round your intermediate calculations. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.).)

Return on Investment Profit Margin Investment Turnover Operating Income Sales Revenue Average Invested Assets
% % $48,000.00 $701,000.00 $1,540,000.00
% 9.30 % 0.37 $87,745.50 $2,550,000.00
% 15.70 % 1.20 $1,980,000.00
12.30 % % 2.10 $516,000.00

Solutions

Expert Solution

Answer:

Return on Investment = (Operating Income / Average invested assets) * 100

Profit Margin = (Operating Income / Sales revenue) * 100

Investment Turnover = (Sales revenue / Average invested assets)

So,

1.

Return on Investment = (Operating Income / Average invested assets) * 100

                                        = ($48,000 / $1,540,000) * 100

                                        = 3.11%

Profit Margin = (Operating Income / Sales revenue) * 100

                        = ($48,000 / $701,000) * 100

                        = 6.85%

Investment Turnover = (Sales revenue / Average invested assets)

= $701,000 / $1,540,000

    = 0.45

2.

Return on Investment = (Operating Income / Average invested assets) * 100

                                        = ($87,745.5 / $2,550,000) * 100

                                        = 3.44%

Profit Margin = (Operating Income / Sales revenue) * 100

         0.093    = $87,745.5 / Sales revenue

Sales revenue = $87,745.5 / 0.093

                           = $943,500

3.

Profit Margin = (Operating Income / Sales revenue) * 100

         0.157    = Operating Income / $1,980,000

Operating income = $1,980,000 * 0.157

                                  = $310,860

Investment Turnover = Sales revenue / Average invested assets

1.2      = $1,980,000 / Average invested assets

Average invested assets = $1,980,000 / 1.2

                                              = $1,650,000

Return on Investment = (Operating Income / Average invested assets) * 100

                                        = ($310,860 / $1,650,000) * 100

                                        = 18.84%

4.

Investment Turnover = Sales revenue / Average invested assets

2.1    = $516,000 / Average invested assets

Average invested assets = $516,000 / 2.1

                                              = $245,714

Return on Investment = (Operating Income / Average invested assets) * 100

                             0.123 = Operating Income / $245,714

Operating Income       = $245,714 * 0.123

                                          = $30,223

Profit Margin = (Operating Income / Sales revenue) * 100

                        = ($30,223 / $516,000) * 100

                        = 5.85%


Related Solutions

Conrad, Inc. recently lost a portion of its records in an officefire. The following information...
Conrad, Inc. recently lost a portion of its records in an office fire. The following information was salvaged from the accounting records.Cost of Goods Sold$69,000Work-in-Process Inventory, Beginning12,100Work-in-Process Inventory, Ending9,800Selling and Administrative Expense17,000Finished Goods Inventory, Ending17,200Finished Goods Inventory, Beginning?Direct Materials Used?Factory Overhead Applied12,800Operating Income14,440Direct Materials Inventory, Beginning11,360Direct Materials Inventory, Ending6,280Cost of Goods Manufactured63,760Direct labor cost incurred during the period amounted to 1.5 times the factory overhead. The CFO of Conrad, Inc. has asked you to recalculate the following accounts and to...
Conrad, Inc. recently lost a portion of its records in an office fire. The following information...
Conrad, Inc. recently lost a portion of its records in an office fire. The following information was salvaged from the accounting records. Cost of Goods Sold $ 74,500 Work-in-Process Inventory, Beginning 14,300 Work-in-Process Inventory, Ending 10,900 Selling and Administrative Expense 19,750 Finished Goods Inventory, Ending 20,225 Finished Goods Inventory, Beginning ? Direct Materials Used ? Factory Overhead Applied 13,900 Operating Income 15,045 Direct Materials Inventory, Beginning 11,855 Direct Materials Inventory, Ending 6,665 Cost of Goods Manufactured 68,930 Direct labor cost...
Conrad, Inc. recently lost a portion of its records in an office fire. The following information...
Conrad, Inc. recently lost a portion of its records in an office fire. The following information was salvaged from the accounting records. Cost of Goods Sold $65,000 Work-in-Process Inventory, Beginning 10,500 Work-in-Process Inventory, Ending 9,000 Selling and Administrative Expense 15,000 Finished Goods Inventory, Ending 15,000 Finished Goods Inventory, Beginning ? Direct Materials Used ? Factory Overhead Applied 12,000 Operating Income 14,000 Direct Materials Inventory, Beginning 11,000 Direct Materials Inventory, Ending 6,000 Cost of Goods Manufactured 60,000 Direct labor cost incurred...
Question 2 Conrad, Inc. recently lost a portion of its records in an office fire. The...
Question 2 Conrad, Inc. recently lost a portion of its records in an office fire. The following information was salvaged from the accounting records. Cost of Goods Sold $ 67,500 Work-in-Process Inventory, Beginning 11,500 Work-in-Process Inventory, Ending 9,500 Selling and Administrative Expense 16,250 Finished Goods Inventory, Ending 16,375 Finished Goods Inventory, Beginning ? Direct Materials Used ? Factory Overhead Applied 12,500 Operating Income 14,275 Direct Materials Inventory, Beginning 11,225 Direct Materials Inventory, Ending 6,175 Cost of Goods Manufactured 62,350 Direct...
Waddell Company had the following balances in its accounting records as of December 31, 2015:   ...
Waddell Company had the following balances in its accounting records as of December 31, 2015:      Assets   Liabilities and Equity      Cash $ 55,000      Accounts Payable $ 27,000      Accounts Receivable 53,000      Common Stock 89,000      Land 28,000      Retained Earnings 20,000      Total $ 136,000      Total $ 136,000    The following accounting events apply to Waddell Company's 2016 fiscal year: Jan. 1 Acquired $56,000 cash from the issue of common stock. Feb. 1 Paid $5,700 cash in advance for a one-year lease for...
Waddell Company had the following balances in its accounting records as of December 31, 2018: Assets...
Waddell Company had the following balances in its accounting records as of December 31, 2018: Assets Liabilities and Equity Cash $ 54,000 Accounts Payable $ 23,000 Accounts Receivable 44,000 Common Stock 88,000 Land 31,000 Retained Earnings 18,000 Totals $ 129,000 $ 129,000 The following accounting events apply to Waddell Company’s 2019 fiscal year: Jan. 1 Acquired $52,000 cash from the issue of common stock. Feb. 1 Paid $5,400 cash in advance for a one-year lease for office space. Mar. 1...
A computer virus destroyed some of the accounting records for Hampton Furniture Company for the periods...
A computer virus destroyed some of the accounting records for Hampton Furniture Company for the periods of 2017-2019. The following information was salvaged from the computer system. 12/31/17 12/31/18 12/31/19 Beginning direct materials $ 50,250 F $ 45,210 Purchases of direct materials A 65,250 70,125 Ending direct materials 34,165 45,210 L Direct materials used 91,385 54,205 M Direct labor B 155,050 162,000 Manufacturing overhead 115,325 G 127,145 Total manufacturing costs C 319,255 364,130 Beginning work-in-process inventory 36,450 H 29,635 Ending...
Last Tuesday, Cute Camel Woodcraft Company lost a portion of its planning and financial data when...
Last Tuesday, Cute Camel Woodcraft Company lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Gamma is 11.3%, but he can't recall how much Cute Camel originally invested in the project nor the project's net present value (NPV). However, he found a note that detailed the annual net cash flows expected to be generated by Project Gamma. They...
Last Tuesday, Fuzzy Button Clothing Company lost a portion of its planning and finacial data when...
Last Tuesday, Fuzzy Button Clothing Company lost a portion of its planning and finacial data when its server and its backup server crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Delta is 14.6%, but he can't recall how much Fuzzy Button originally invested in the project nor the project's net present value (NPV). However, he found a note that contained the annual net cash flows expected to be generated by Project Delta. They are:...
On Monday, Eagle Manufacturing lost a portion of its planning and financial data when both its...
On Monday, Eagle Manufacturing lost a portion of its planning and financial data when both its main and backup servers crashed. The company's CFO remembers that the IRR of project Alpha is 11.3%, But he can't recall how much Eagle originally invested in the project nor the project's NPV. However, he found a note that detailed the annual net cash flows expected to be generated by Project Alpha. They are: Year 1 $2,000,000 Year 2 $3,750,000 Year 3 $3,750,000 Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT