After analysing the financial data of Q-Constructions, you notice that they are trending in the right direction. A new 12-month construction proposal has come to the company worth $1,000,000 and an important question is whether it will be financially viable. They want you to analyse the proposal, in particular, the recommended cash flow schedule and to understand the key financial points during the construction project. The following cash flow schedule is summarised below. To ensure that all upfront and on-going outlay costs are covered in advance, Q-Constructions incur an initial start-up cost of $200,000. The proposal states that they will receive a deposit from the client of 10% of the total project cost at the beginning. They then receive four equal instalment payments of 20% of the total project cost associated to project milestones from the client at the end of the 2nd, 6th, 8th and 10th month. Finally, they receive the last 10% project milestone on lock-up which occurs at the end of the 12th month. Q-Constructions has ongoing project costs of $20,000 to pay salaries and services at the end of each month. In additional, there are material costs of $100,000 associated for each of the project milestones at the end of the 2nd, 6th, 8th and 10th month. The current cost of capital for company is 8% per annum compounded monthly. You have been tasked with the important objective to determine whether this future project is financially viable. In addition, they want you to determine which milestone is needed to be completed in the project proposal such that it will be financially viable. It’s time to show your Quants knowledge and expertise with Excel to determine the financial viability of this project. In a worst-case scenario where the project does not proceed, and the initial outlay is paid. Calculate the amount of interest that would have accrued on an amount of $200,000 at the end of 12 months with an interest rate of 8% p.a compounded monthly
After analysing the financial data of Q-Constructions, you notice that they are trending in the right direction. A new 12-month construction proposal has come to the company worth $1,000,000 and an important question is whether it will be financially viable. They want you to analyse the proposal, in particular, the recommended cash flow schedule and to understand the key financial points during the construction project. The following cash flow schedule is summarised below.
To ensure that all upfront and on-going outlay costs are covered in advance, Q-Constructions incur an initial start-up cost of $200,000. The proposal states that they will receive a deposit from the client of 10% of the total project cost at the beginning. They then receive four equal instalment payments of 20% of the total project cost associated to project milestones from the client at the end of the 2nd, 6th, 8th and 10th month. Finally, they receive the last 10% project milestone on lock-up which occurs at the end of the 12th month. Q-Constructions has ongoing project costs of $20,000 to pay salaries and services at the end of each month. In additional, there are material costs of $100,000 associated for each of the project milestones at the end of the 2nd, 6th, 8th and 10th month. The current cost of capital for company is 8% per annum compounded monthly. You have been tasked with the important objective to determine whether this future project is financially viable. In addition, they want you to determine which milestone is needed to be completed in the project proposal such that it will be financially viable. It’s time to show your Quants knowledge and expertise with Excel to determine the financial viability of this project.
In a worst-case scenario where the project does not proceed, and the initial outlay is paid. Calculate the amount of interest that would have accrued on an amount of $200,000 at the end of 12 months with an interest rate of 8% p.a compounded monthly.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
