Please complete the exercises in Word or Excel

Please complete the exercises in Word or Excel
You are asked by a Swedish company that assembles computers to draw up a
by-nature and by-function income statement for year n. You are provided with the following
information:
Retail price of a PC: €1500.
Cost of various components:
Parts Price Opening inventory Closing inventory
Case 50 5 13
Motherboard 200 8 2
Processor 300 4 11
Memory 100 6 4
Graphic card 50 1 13
Hard disk 150 5 10
Screen 200 3 3
DVD combo 50 7 19
Over the financial period, the company paid out €60 000 in salaries and social security
contributions of 50% of that amount. The company produced 240 PCs. Closing stock of
finished products was 27 units and opening stock 14 units.
At the end of the financial period, the manager of the company sells the premises that he
had bought for €200 000 three years ago (which was depreciated over 40 years) for €230
000, it now occupies old premises that are fully depreciated, and pays off a €12 000 loan
on which the company was paying interest at 5%. What impact do these transactions have
on EBITDA, operating profit and net income? Tax is levied at a rate of 35%.
Over the course of the financial period, by how much did the company/the lenders/the
company manager (who owns 50% of the shares) get richer/poorer?
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code “Newclient”

The post Please complete the exercises in Word or Excel appeared first on Superb Professors.

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"