In a project of HUL, the company shows initial cash out flow of Rs. 5200. The cash inflow in this regard is Rs. 1600 for 6 times.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

1. In a project of HUL, the company shows initial cash out flow of Rs. 5200. The cash inflow in this regard is Rs. 1600 for 6 times.

i. Calculate the Internal Rate of Return (IRR) for the project.

ii. Also calculate the present value (PV) of the project to cross check IRR obtained.

 

2. Enter the following data in a worksheet. This data is about a shop selling different items with a discounted rate.

item code Item Name Unit Price Units Total Price

I_YourRollNo Powder 50 50

I_YourRollNo+1 soap 25 70

…………+2 shampoo 155 100

……….+3 detergent 35 75

………..+4 Body Spray 240 150

……….+5 Hand wash 90 200

 

Compute the blank columns as given below:

I) TOTAL PRICE = UNITS X UNIT PRICE

II) Name all the cells for units as ‘unit’ (naming the range of cells) and calculate the total number of units.

III) Arrange the data in item code wise descending manner using SORT command.

IV) Make a pivot table and pivot chart [item wise Total price].

V) Add a column as Category and fill colour as given below: If Unit Price <=50 Category = “Green”

Unit Price >=50 & =<100 Category = “Orange” Unit Price >=100 & =<150 Category = “Yellow” Unit Price >=150 Category = “Deep Blue”

 

3. In sheet4 create a table having 5 fields (Name, Sub1,Sub2,Sub3,Total). Then enter 4 records. Now using MACRO do autosum and autofill to use the same in different place of the sheet.

 

4. Create the following in 2 different sheets then use Vlookup function to find the corresponding Employee Designation based on Employee ID.

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme