Reference no: EM131311847
Excel Assignments
This assignment is to develop an Excel Spreadsheet for a company. 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).
You may work in groups of up to 3 students for this assignment. You may submit this assignment on Canvas or by sending it to me by email.
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
|
Major differences between us and multinational operations
: What are the major differences between U.S. and multinational operations that affect strategic management?- Should transnational operations at the company be expanded or reduced? Why?
|
|
What is considered to be the normal rate of return
: Think about a firm and its investments. What is considered to be the normal rate of return? What type of specific cost would this be to a firm?
|
|
Equivalent annual compound interest rate
: If Rosie withdraws all of the money from this account after 16 years, what is the equivalent annual compound interest rate for this investment assuming this rate compounds weekly? Your answer should be a percent rounded to the nearest 2 decimal p..
|
|
What will be the firms cash cycle
: Suppose that LilyMac Photography has annual sales of $240,000, cost of goods sold of $175,000, average inventories of $5,500, average accounts receivable of $27,000, and an average accounts payable balance of $18,200. Assuming that all of LilyMac’s s..
|
|
Develop an excel spreadsheet for a company
: FIN 340 Excel Assignments. This assignment is to develop an Excel Spreadsheet for a company. 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 posi..
|
|
Derive and graph the aggregate demand curve
: ASB-3514 INDUSTRIAL ORGANISATION - Derive and graph the aggregate demand curve and aggregate marginal revenue curve and calculate the profit maximising uniform price, as well as the quantity, profits, consumer surplus and dead weight loss under th..
|
|
Compare two market model of perfect competition and monopoly
: Write a paper (Two pages), comparing the two market models of perfect competition and monopoly. Compare on the following points: characteristics, output, price, effiency in resource utilization, and employment.
|
|
Series of a-rated debentures
: What is the maximum price that you would pay up for a series of A-rated debentures (i.e., corporate bonds) each with a face value of $1000, that promise to pay 33 more semi-annual coupons of $18.25 each at a yield to maturity of 2.91%?
|
|
Write your understanding of how the economic machine works
: Write down your understanding of 'How The Economic Machine Works' and make sure to support it with your real life experience. (For Example, you can connect it with Tim Hortons, ESSO Gas Station, Subway Eat Fresh etc).
|