Reference no: EM131305659
FIN 340 Excel Assignment
You may work in groups of up to 3 students for this assignment.
You have just been hired as a financial analyst for a small firm whose employees do not have much experience with Excel. As your first task, you have been asked to develop a simple Excel spreadsheet that your manager can input values for a project the firm is considering to determine whether the project is acceptable. The capital budgeting techniques that the firm uses: Net Present Value; Internal Rate of Return; Profitability Index.
The spreadsheet should contain cells where the manager can input cash flows associated with the project, and the project hurdle rate (or cost of capital). Assume that the longest project that will be considered is a ten-year project. The spreadsheet should contain cells that calculate the NPV, IRR and PI once the inputs have been entered.
Because this is for a manager that has not used Excel before, the spreadsheet should include instructions on how to enter in the inputs (for example, should the initial investment be entered in as a negative or positive value). It should also be formatted so that the manager is able to immediately see whether the project is acceptable or not, without the manager needing to know what the criteria are for accept/reject for a particular technique. In other words, based on the value (NPV, IRR, etc.) generated by the project, there should be a cell that indicates whether the project should be accepted or not.
Finally, the manager's background is in design, so he likes to see documents that are visually pleasing. This assignment is worth 5 points. You have the opportunity to earn one extra credit point if you also set up a calculation and provide the accept/reject decision using the payback period. To earn the extra credit point, you will have to use nested =IF statements to figure out the payback period in one cell. For your firm, the maximum acceptable payback period is 4 years.
The following Excel functions may come in useful: =NPV, =IRR, =IF
Attachment:- Excel Functions.rar
|
Description of the motivational practices
: How a contemporary company motivates employees to support the development of an effective and competitive organization. Identification of a company that utilizes effective motivational practices. Description of the motivational practices.
|
|
Two beliefs your organization has about management
: Which of your current beliefs (choose one or two) around Management do you wish could change (describe it) and why? Identify one or two beliefs your organization has (that may be different from your own) about Management (describe it) that you would ..
|
|
How many adults in total said they watch the cooking channel
: Regardless of the number of dogs or cats someone owns (including zero!), about how many U.S. adults in total said they watch the Cooking Channel?
|
|
Discuss about the focus of juvenile justice
: During the course of processing a youthful offender, under what circumstances, if any, should the juvenile justice system abandon rehabilitation and focus on punishment?What criteria should be used when deciding whether to focus primarily on punish..
|
|
Financial analyst for a small firm
: FIN 340 Excel Assignment. You have just been hired as a financial analyst for a small firm whose employees do not have much experience with Excel. As your first task, you have been asked to develop a simple Excel spreadsheet that your manager can ..
|
|
Analyze commonly accepted forensic techniques
: Explain how to process and retrieve trace evidence involving firearms.Evaluate accepted methodologies employed in contemporary crime scene management relative to firearms. Analyze commonly accepted forensic techniques and contemporary specialized tec..
|
|
Discuss about the police leadership and organizations
: Discuss about the Police leadership and Organizations.Write two paragraphs on your opinion on the subject provided and what you would or would not change based on your beliefs, opinions and thoughts.
|
|
Draw an arbitrary budget constraint for a person
: Draw an arbitrary budget constraint for a person assuming that he or she receives no workers' compensation - Analyze the difference in the labor supply incentive effects of these two programs.
|
|
Determine the family and school risk factors for gang
: Discuss the three models used to understand the relationship between delinquency and gang involvement. Which do you agree with most? Why?Determine the family and school risk factors for gang involvement.
|