accounting project

Instructions.zip

Home >Business & Finance homework help >Accounting homework help >accounting project

Awesome Case Template.xlsx

Normalized income statement

PREPARER'S NAME	INCOME STATEMENT					Ratio	Ratio	Positive/Negative
Account Title	2010	2011	2012	2013	2014	Awesome	Industry	Compared
Add additional rows as needed
See annoucements
Normalization Adjustments	Add adjustments, ie amounts from normalization, here for each year
Net Income
Notes: Use years 2010 through 2014 to get ratios and trends
Notes: Use years 2010 through 2014 to get ratios and trends

Valuation of Awesome

Sheet3

Awesome Case.pdf

��

,QIRUPDWLRQ� QHHGHG�IRU� QRUPDOL]DWLRQ�HQWULHV

�

��

�� ?

$ZHVRPH 8QDGMXVWHG�,QFRPH�6WDWHPHQW

3HUFHQWDJH�RI�6DOHV � -I

��

1HW 6DOHV &RVW�RI 6DOHV *URVV�3URILW

��

ā�?

2SHUDWLQJ([SHQVHV 6DODULHV DQG:DJHV�

2IILFHUV �&RPSHQVDWLRQ ` 5HWDLO�6DOHV 6DODULHV 0DQDJHULDO6DODULHV 2WKHU�6DODULHV DQG :DJHV

��

ā� ��

��

7RWDO 6HOOLQJ�([SHQVHV�

��

7UDYHO� �(QWHUWDLQPHQW $XWR ,QVXUDQFH ā�� 7HOHSKRQH $GYHUWLVLQJ� �3URPRWLRQ 0DUNHW�5HVHDUFK 2WKHU � 7RWDO

*HQHUDO� �$GPLQLVWUDWLYH�� /HJDO �$FFRXQWLQJ 7D[HV ,QVXUDQFH 2IILFH 6XSSOLHV 'RQDWLRQV 3RVWDJH �)UHLJKW 5HQW 2WKHU 7RWDO

7RWDO 2SHUDWLQJ�([SHQVHV

��

�� ā

��

2SHUDWLQJ�(%,7'$�� 'HSUHFLDWLRQ� �$PRUWL]DWLRQ

��

2SHUDWLQJ ,QF �/RVV��(%,7�� 0LVFHOODQHRXV ^,QF� ([S� ,QWHUHVW ([SHQVH

��

,QFRPH��/RVV� %HIRUH 7D[HV ,QFRPH�7D[HV

��

1HW ,QFRPH��/RVV�

5HWDLQHG (DUQLQJV ��%HJ RI <U 'LYLGHQGV

��

2WKHU $GMXVWPHQWV ��

5HWDLQHG(DUQLQJV��(QGRI<U ��

��2SHUDWLQJ�(%,7'$� �2SHUDWLQJ�(DUQLQJV��EHIRUH�,QWHUHVW��7D[HV��'HSUHFLDWLRQ �$PRUWL]DWLRQ�� 2SHUDWLQJ�,QFRPH��/RVV�� 2SHUDWLQJ�,QFRPH��/RVV��(DUQLQJV�%HIRUH�,QWHUHVW�DQG 7D[HV

��ā� ,

��

$ZHVRPH�3URGXFWV

��

� ��

��

7RWDO�&XUUHQW�$VVHWV �� 3URSHUW\��3ODQW�DQG�(TXLS

��

� ��

��

6WRFNKROGHUV �(TXLW\�

&RPPRQ�6WRFN ��

7RWDO�/LDE� �6KDUHKROGHUV �(TXLW\��

$GGLWLRQDO�3DLG�,Q�&DSLWDO �� 5HWDLQHG�(DUQLQJV �� 7RWDO�6KDUHKROGHUV �(TXLW\ ��

/7�'HEW��1HW�&XUUHQW�3RUWLRQ� ��

7RWDO�/7�/LDELOLWLHV �� 7RWDO�/LDELOLWLHV ��

,QFRPH�7D[HV�3D\DEOH ��

7RWDO�&XUUHQW�/LDELOLWLHV ��

/RQJ�7HUP�/LDELOLWLHV�

'XH�%LOOV� �*LIW�&HUWLILFDWHV �� $GYDQFHV�)URP�$IILOLDWHV �� $FFUXHG�6DODULHV ��

&XUUHQW�/LDELOLWLHV� &XUUHQW�3RUWLRQ��/7�'HEW �� $FFRXQWV�3D\DEOH ��

7RWDO�2WKHU�$VVHWV ��

7RWDO�$VVHWV ��

/,$%,/,7,(6� �(48,7<

��

2WKHU�$VVHWV��

&DVK�9DOXH�/LIH�,QVXUDQFH �� ,QYHVWPHQWV ��

3UHSDLG�([SHQVHV �� 2WKHU�&XUUHQW�$VVHWV ��

� �

)XUQLWXUH�DQG�)L[WXUHV �� /HDVHKROG��,PSURYHPHQWV �� 7UDQVSRUWDWLRQ��(TXLSPHQW �� 7RWDO �� /HVV��$FFXPXODWHG�'HSUHFLDWLRQ �� 1HW�)L[HG�$VVHWV ��

&XUUHQW�$VVHWV��

5HF��5HODWHG��&RPSDQLHV �� ,QYHQWRU\ ��

��

3HUFHQWDJH�RI $66(76 7RWDO�$VVHWV

��$FFRXQWV��5HFHLYDEOH�7UDGH ��&DVK

3UHSDUHU V�1DPHLL 6&+('8/(�� $ZHVRPH�3URGXFWV 8QDGMXVWHG�%DODQFH�6KHHWV

ā �81$8',7('� �$//�180%(56�,1�7+286$1'6�

��

Instructions.docx

Attached below are a pdf document of the AWESOME CASE questions and an excel TEMPLATE the professor sent to give us an idea of how to do it.

1- The excel sheet should not exceed the margins when printed out.

2- All calculations and equations should be shown in the excel boxes - formulas behind the cells

3- PLEASE Leave question 2-a until the end because the professor might make changes to the unadjusted balance sheet or may even exclude it from the assignment.

4- For question 2-b, we are ONLY required to do the normalized income statement and NOT a common size Income Statement.

5- If possible, when you finish any question or section send it to me so I can have time to review and prepare before I submit the whole case on the 18th.

Thank you.