Question
Show the Cash Flow Tables and Spreadsheet please: a) Crystallex International Corp announced a $153million investment to double the capacity of its gold mine at
Show the Cash Flow Tables and Spreadsheet please:
-
a) 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.
-
b) Joetakesouta$250,000mortgageloanonhishomeattheinterestrate4.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 payments 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 so much
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started