DRAW CASH FLOW TABLES AND SPREADSHEET

-Crystallex International Corp announced a $153million investment to double the capacity of its gold mine at Las Cristinas, Venezuela. The investment will allow 20,000 metric tons of additional ore to be mined daily, yielding 2.54 grams (0.0.0896 ounce) of gold per ton of ore. Assume that the investment is divided over two years, with the first year of production reaching 6,000 tons per day (250 production-days per year), and increasing 5,000 tons per day each year until reaching the capacity of 20,000 tons per day. Assume further that production costs are $6.91 per ton and revenues are $320 per ounce of gold. Finally, assume that the annual maintenance costs are $20 million and the charge to clean up the mine after 20 years of production is $15 million. Using a spreadsheet, draw the cash flow diagram (table) for this investment.

- Joe takes out a$250,000 mortgage loan on his home at the interest rate4.5%. His monthly payment is $1912.48. Use spreadsheets to display interest payments and principal payments for each month for the entire 180 months. What is the total interest paid for the entire loan? Display the first 10 months and the last 10 months (and hide the rest) of the cash flow table generated.

Thank you very much