I would like a free quote
Microsoft Word - Post-Assignment - Module 1 - Accounting - 2021.doc MBA – International Hospital and Healthcare Management Autumn 2021 Post-Assignment – Module 1 Accounting Task 1: Download the official 2020 annual financial statements for Pfizer from the internet. Extract the following information for the firm’s fiscal years 2020 and 2019: (a) total revenues, (b) depreciation and amortization, (c) operating income after depreciation, (d) net earnings attributable to common shareholders, (e) common shareholders’ equity (f) total equity (g) total non-current liabilities, and (h) total assets. Furthermore, calculate the following financial ratios for 2020: (1) net profit margin, (2) net operating margin (3) return on equity, (4) return on assets, (5) total asset turnover, (6) debt/equity ratio (7) debt ratio. Provide your calculations in an excel sheet (i.e. explicitly provide the formulas for your calculated ratios as well as the underlying figures). Try to present the information in an easily understandable format. Please label the table of your excel file “task 1”. Task 2: On Dec 31, 2020 Jane, Jules and John started the 3j.com company. The idea is to buy and resell a newly developed easily useable sport watch (called iMon) which can monitor cardiac activity. - Each of the three founders paid in € 35,000 equity capital in cash. - In addition, Jane brought in new a building which serves to hold the inventory (value of building: € 230,000; value of land: € 70,000; expected life time 50 years) - Jules provided the company with a 2-year old van currently valued at € 23,000 (expected remaining use: 3 years; assumed value in 3 years: € 5,000). - John attributed office furniture and appliances worth € 32,000 (expected use: 5 years; scrap value: € 0). - Together, they acquire a 2-year loan from NaughtyBank (amount € 40,000, interest 5% per quarter). - Jane buys 500 iMon units for € 150 each (shipment costs included, payable next month). Insert another table into your excel file (labelled “task 2”) and record the above accounting events in a systematic manner (use a separate column for each record, just as in the lecture). Please provide also the Balance Sheet of 3j.com for the year end 2020 (Income Statement and Cash Flow Statement NOT required). Task 3: During the first quarter of 2021 the following events take place at 3j.com: - On Jan. 1, John rents a shop located at the heart of the city (monthly rent € 10,000; payable at first day each month) and Jules buys shop furniture for € 29,000 (transportation costs € 200 and installment costs € 800; expected use 5 years; scrap value € 0). - During the quarter, 3j.com orders 1,400 additional iMon units at € 160 to be paid in April. - It sells 1,800 units at a price of € 350 during the quarter (cash payment, assume FIFO). - Gasoline for deliveries costs € 600 per month (paid in cash). - As the business runs well, they hire a sales clerk (starting Feb 1; € 2000 monthly wage incl. everything; paid in cash) and buy an additional delivery van for € 33,000 cash on March, 1 (expected use: 5 years; value in 5 years: € 3,000). Insert another table into your excel file (labelled “task 3”) and record all necessary accounting events (separate column for each record) and prepare the Balance Sheet for 3j.com as of March 31, 2021 along with their Income Statement and Cash Flow Statement for the first quarter of 2021. Don’t forget taxes (25%) and think about other necessities! Please hand in ONE Excel file containing your answers and calculations for task 1, 2 and 3. Please also upload the financial statement of Pfizer, which you used to answer task 1. Deadline is Monday, Nov. 1. Please note: Make all calculations explicit inside these sheets (i.e. type in formulas not just results). Structure your spreadsheets such that the information is easily understandable for a time-constrained reader. Grading is based on both “content” and “appearance”.