It is important to consider the time value of money along with financial risk when making financial decisions. Determine the best course of action for your company using the information below:

• Assume the stock market returns 11.3% per year on average.
• Your company has $100,000 to spend on the down payment on the purchase of a new office.
• A new office will cost $500,000
• To rent a new office it will cost your company $3,500 per month and you will need to sign a 3-year lease.
• Find any other information that is necessary to perform the calculation such as the current market rate for a commercial loan for 7%.

What should vou do: buy an office or lease? Choose the best answer and justify your answer by calculating the time value of money. What other factors should you use besides the time value of money? Why? And how would It look in a excel worksheet?