Question

In: Finance

After analysing the financial data of Q-Constructions, you notice that they are trending in the right...

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 price at the beginning. They then receive four equal instalment payments of 20% of the total project price 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.
(a)   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. Do not use EXCEL for this calculation.
(b)   Set up a cash inflow and outflow for the 12-month construction project proposal based on the information provided by the company above. By using the current 8% p.a compounded monthly cost of capital, calculate the Net Present Value of this proposal and whether it is financially viable project. Use EXCEL to calculate the net present value of the current situation.

Solutions

Expert Solution

1)

Initial Cost                     = 200000

Cost of capital               = 8% compounded monthly

No of time period       = 12

Total amount at end of 12 months     = P(1+r/n)nt

Where, P is Principle Amount, r is interest rate, n is no of times interest applied per time period, t is the total no of time period elapsed

  Total amount at end of 12 months          =200000 (1+0.08/12)1x12

                                                     =216599.90

Amount of Interest at the end of 12 months       = 216599.90 – 200000

                                                                                                = 16599.90


Related Solutions

After analysing the financial data of Q-Constructions, you notice that they are trending in the right...
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...
If a patient is "looking at you" but what you notice is that the patient's right...
If a patient is "looking at you" but what you notice is that the patient's right eye is looking directly forward, while, at the same time, the patient's left eye is looking up and medially, which muscle is not working correctly?
After analysing several months of sales data, the owner of an appliance store produced the following...
After analysing several months of sales data, the owner of an appliance store produced the following joint probability distribution of the number of refrigerators (x) and stoves (y) sold daily. Refrigerators (x) Stoves (y) 0 1 2 0 0.08 0.14 0.12 1 0.09 0.17 0.13 2 0.05 0.18 0.04 a Find the marginal probability distribution of the number of refrigerators sold daily. b Find the marginal probability distribution of the number of stoves sold daily. c Compute the mean and...
You are analysing data collected by a rover on the moon. You may assume that the...
You are analysing data collected by a rover on the moon. You may assume that the rover starts at the origin (0,0,0), and that each coordinate it transmits contains an East-West component, a North-South component and an altitude component, relative to the origin. Let positive movement in the i direction be East, positive movement in the j direction be North, and positive movement in the k direction be increasing altitude. All values are in meters. Assume the moon is flat...
The financial year for Crystal Catering Services ends on 30 June. After analysing the accounting records...
The financial year for Crystal Catering Services ends on 30 June. After analysing the accounting records and other data for the business of Crystal Catering Services, the following information is made available for the year ended 30 June 2020. Crystal Catering Services sub-lets space in its building of $2,400 (excluding GST) per month. Crystal Catering Services has not received the rent for June 2020. Crystal Catering Services borrowed $15,000 from Metro Bank on 2 February 2020. The principal, plus 5%...
Q-Constructions has tasked you to investigatethe number of construction projects per year for which the...
Q-Constructions has tasked you to investigate the number of construction projects per year for which the company would need to break-even and make a profit of $500,000 per year. The average price of a building contract is $700,000 per project. The following are the fixed and variable costs of Q-Constructions in Table 2: Description Cost Office Space 55,000 Professional Staff Salaries 205,000 Insurances 50,000 Machine Maintenance 80,000 Website Management 30,000 On-site workers’ salaries $120,000 per project Average Material Cost 60%...
A patient is lying on his right side in bed. When turning the patient, you notice...
A patient is lying on his right side in bed. When turning the patient, you notice reddened skin on his right trochanter. How can you determine if this is a stage I pressure injury? What are some risk factors contributing to pressure injuries?
Before you start analysing the firm's financial statements, you will need to obtain industry averages for...
Before you start analysing the firm's financial statements, you will need to obtain industry averages for each of the standard financial statement ratios. They are provided below. 2019 2020 2021 Industry Averages Profitability Ratios Return on equity 21.3% 21.2% 19.6% 22.0% Return on Capital employed 12.9% 13.5% 13.5% 12.8% Operating Profit Margin 14.7% 18.2% 23.0% 14.4% Gross Profit Margin 54.7% 52.0% 49.3% 44.8% Efficiency Ratios Average Inventory Turnover period 79.8 83.3 93.0 78.8 Average settlement period for Accounts Receivable 28.0...
You are driving up a long, inclined road. After 1.40 mi you notice that signs along...
You are driving up a long, inclined road. After 1.40 mi you notice that signs along the roadside indicate that your elevation has increased by 530 ft . You may want to review (Pages 62 - 65) . What is the angle of the road above the horizontal? How far do you have to drive to gain an additional 130 ft of elevation?
After having dinner at a fancy restaurant furnished with navy blue table runner, you notice the...
After having dinner at a fancy restaurant furnished with navy blue table runner, you notice the sleeves of your white wool jacket has turned blue. What do you think caused this to happen? What standard test method would you use to evaluate the color?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT