Consider the project described below:
Expected annual inflation rate	4%
Cost of capital (real rate)	5%
Corporate tax rate	30%
Year	0	1	2	3	4	5	Notes
Initial investment	200,000.00
Straight line depreciated to zero over 5-year life; Salvage value is zero
Revenue		80,000.00					Increases at 8% per year in nominal terms
Variable costs		20,000.00					Increases at 6% per year in nominal terms
Fixed costs		10,000.00					Increases at 1% per year in real terms
Complete the highlighted cells and find the NPV for the project

 

Transcribed Image Text:

Deliverables include the following: 1. Dependency diagram of the table after converting to 1NF indicating all the dependencies 2. Dependency diagram for each table after converting to 2NF indicating all the dependencies 3. Dependency diagrams of each table after converting to 3NF indicating all the dependencies 4. Create normalized fully attributed Entity Relationship diagram in MS Visio showing all the entities, their relationships, and cardinalities (Add additional attributes to each table as appropriate: Make sure not to end up de-normalizing the tables in the process). 5. Answer these specific questions: a. How will you maintain historical accuracy of "product price"? b. Did you identify any derived attribute? If yes, how did you handle it? Note: You need to upload to Moodle before the due date and time the following: MS Word document showing items 1, 2, 3, and 5 above (you could use Word features such as Insert Table, and Insert Shapes tools to draw the dependency diagram - A sample drawing is shown in page 3) MS Visio file showing item 4 above Order ID 1001 1004 1005 1010 1007 1002 1003 1006 1009 1008 10573 Cust Type 2 2 3 2 3 1 3 1 3 2 3 Cust Name Type Gold Gold Platinum Gold Platinum Silver Platinum Silver Platinum Gold Platinum Cust ID 103 103 102 103 101 102 101 102 104 105 104 Cust Name John Adams John Adams Sara Matthews John Adams Rick Scott Liz Thong Rick Scott Liz Thong Tony Hernandez Neal Katyal State TX TX TX TX MO MO MO MO CA CA Tony Hernandez CA Prod. JD 34 56 78 33 23 35 63 34 56 23 14 63 14 63 78 34 14 72 56 33 23 35 23 34 63 35 78 33 Prod.Name Black pepper Garlic powder Hakka Noodles Mustard sauce Paprika Soy Sauce Vegie-spread Black pepper Garlic powder Paprika Tofu Vegie-spread Tofu Vegie-spread Hakka Noodles Black pepper Tofu Mozzarella sticks Garlic powder Mustard sauce Paprika Soy Sauce Paprika Black pepper Vegie-spread Soy Sauce Hakka Noodles Mustard sauce Unit Price 13.25 14.25 22.00 12.00 12.00 11.00 21.00 13.25 14.25 12.00 8.50 21.00 8.50 21.00 22.00 13.25 8.50 34.80 14.25 12.00 12.00 11.00 12.00 13.25 21.00 11.00 22.00 12.00 Qty. Tax_ Rate 7.25% 7.25% 7.25% 7.25% 7.25% 7.25% 7.25% 12 4 4 5 in com 8 3 4 5 chin 6 NM in 2 3 5 3 5 2 27 2 3 5 24 50 1 5 6 5 9 25 7.25% 7.25% 7.25% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% Total 170.53 61.13 94.38 64.35 102.96 35.39 90.09 71.05 91.70 25.74 27.03 111.30 27.03 111.30 46.64 28.09 63.07 73.78 45.32 63.60 311.76 595.38 12.99 71.72 136.40 59.54 214.34 324.75 Deliverables include the following: 1. Dependency diagram of the table after converting to 1NF indicating all the dependencies 2. Dependency diagram for each table after converting to 2NF indicating all the dependencies 3. Dependency diagrams of each table after converting to 3NF indicating all the dependencies 4. Create normalized fully attributed Entity Relationship diagram in MS Visio showing all the entities, their relationships, and cardinalities (Add additional attributes to each table as appropriate: Make sure not to end up de-normalizing the tables in the process). 5. Answer these specific questions: a. How will you maintain historical accuracy of "product price"? b. Did you identify any derived attribute? If yes, how did you handle it? Note: You need to upload to Moodle before the due date and time the following: MS Word document showing items 1, 2, 3, and 5 above (you could use Word features such as Insert Table, and Insert Shapes tools to draw the dependency diagram - A sample drawing is shown in page 3) MS Visio file showing item 4 above Order ID 1001 1004 1005 1010 1007 1002 1003 1006 1009 1008 10573 Cust Type 2 2 3 2 3 1 3 1 3 2 3 Cust Name Type Gold Gold Platinum Gold Platinum Silver Platinum Silver Platinum Gold Platinum Cust ID 103 103 102 103 101 102 101 102 104 105 104 Cust Name John Adams John Adams Sara Matthews John Adams Rick Scott Liz Thong Rick Scott Liz Thong Tony Hernandez Neal Katyal State TX TX TX TX MO MO MO MO CA CA Tony Hernandez CA Prod. JD 34 56 78 33 23 35 63 34 56 23 14 63 14 63 78 34 14 72 56 33 23 35 23 34 63 35 78 33 Prod.Name Black pepper Garlic powder Hakka Noodles Mustard sauce Paprika Soy Sauce Vegie-spread Black pepper Garlic powder Paprika Tofu Vegie-spread Tofu Vegie-spread Hakka Noodles Black pepper Tofu Mozzarella sticks Garlic powder Mustard sauce Paprika Soy Sauce Paprika Black pepper Vegie-spread Soy Sauce Hakka Noodles Mustard sauce Unit Price 13.25 14.25 22.00 12.00 12.00 11.00 21.00 13.25 14.25 12.00 8.50 21.00 8.50 21.00 22.00 13.25 8.50 34.80 14.25 12.00 12.00 11.00 12.00 13.25 21.00 11.00 22.00 12.00 Qty. Tax_ Rate 7.25% 7.25% 7.25% 7.25% 7.25% 7.25% 7.25% 12 4 4 5 in com 8 3 4 5 chin 6 NM in 2 3 5 3 5 2 27 2 3 5 24 50 1 5 6 5 9 25 7.25% 7.25% 7.25% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% Total 170.53 61.13 94.38 64.35 102.96 35.39 90.09 71.05 91.70 25.74 27.03 111.30 27.03 111.30 46.64 28.09 63.07 73.78 45.32 63.60 311.76 595.38 12.99 71.72 136.40 59.54 214.34 324.75