Question

In: Finance

1)Calculate the Cumulative Net amount for this 6-month project. Which month will have the highest demand...

1)Calculate the Cumulative Net amount for this 6-month project. Which month will have the highest demand on your finances? Hint: You are determining what your line of credit amount will be.

2)  calculate the interest you will have to pay to cash flow the project. Interest Rate is 5%. Hint: you need to calculate the cumulative monthly amounts to calculate the monthly interest, if any.

Month Monthly Net
1 $        (28,500)
2 $        (14,760)
3 $           (5,650)
4 $                 200
5 $           22,690
6 $           26,020

Solutions

Expert Solution

Response to part 1)
Month Monthly net (USD) Cumulative balance (USD)
1                      (28,500)                                  (28,500)
2                      (14,760)                                  (43,260)
3                        (5,650)                                  (48,910)
4                             200                                  (48,710)
5                        22,690                                  (26,020)
6                        26,020                                            -  
Note : Cumulative balance is calculated as follows :
Monthly net amount for current month + cumulative balance for previous month
Month 1 will have the highest demand on the finances as the amount of outflow is the highest.
Response to part 2)
Month Monthly net (USD) Cumulative balance (USD) Interest @ 5%
1                       (28,500)                                  (28,500)              (1,425)
2                       (14,760)                                  (43,260)              (2,163)
3                          (5,650)                                  (48,910)              (2,446)
4                               200                                  (48,710)              (2,436)
5                         22,690                                  (26,020)              (1,301)
6                         26,020                                            -                         -  
Note : Interest is taken at 5% and not 5% p.a. as per the question
Interst = Cumulative balance for current month * 5%

Related Solutions

Which of the following returns will give you the highest dollar amount after 6 years? 49%...
Which of the following returns will give you the highest dollar amount after 6 years? 49% total return 6.9% annual return 3.4% semiannual return 0.55% monthly return
1. Calculate the net present value (NPV) for both projects, anddetermine which project should be...
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: YearProject AProject B0-$420,000-$420,0001$140,000$400,0002$230,000$110,0003$331,000$140,000The appropriate discount rate is 8.5%.1. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar.2. Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR.3. Calculate the net present value (NPV) for both projects...
(a) Calculate the net present value (NPV) of a project which requires an initial investment of...
(a) Calculate the net present value (NPV) of a project which requires an initial investment of $243,000 and it is expected to generate a cash inflow of $58,000 each month for 12 months. Assume that the salvage value of the project is zero. The target rate of return is 12 % per annum. (b) An initial investment of $8,720 thousand (i.e. × 1,000) on plant and machinery is expected to generate cash inflows of $3,411 thousand, $4,070 thousand, $5,824 thousand...
Calculate the Net Present Value of a project, which requires an initial investment of $399000 and...
Calculate the Net Present Value of a project, which requires an initial investment of $399000 and it is expected to generate a cash inflow of $29000 each month for 12 months. Assume that the salvage value of the project is zero. The target rate of return is 11% per annum. Write the formula and calculate NPV. Justify the result. Q4. (a) Mr. Yasser Al Harthi, has a Dell Laptop. His laptop has some problems in the motherboard unit, so it...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate the standard errors 3. compare their forecast accuracy Month/Year Unemployment rate Jan-17 5.1 Feb-17 4.9 Mar-17 4.6 Apr-17 4.1 May-17 4.1 Jun-17 4.5 Jul-17 4.6 Aug-17 4.5 Sep-17 4.1 Oct-17 3.9 Nov-17 3.9 Dec-17 3.9 Jan-18 4.5 Feb-18 4.4 Mar-18 4.1 Apr-18 3.7 May-18 3.6 Jun-18 4.2 Jul-18 4.1 Aug-18 3.9 Sep-18 3.6 Oct-18 3.5 Nov-18 3.5
For which of the following goods is the income elasticity of demand likely highest? a. tennis...
For which of the following goods is the income elasticity of demand likely highest? a. tennis lessons b. allergy medication c. clothing d. cell phone contracts
1.) What is the Net Sales amount? Jan. 6 Sold goods for $1,500 to S. Green...
1.) What is the Net Sales amount? Jan. 6 Sold goods for $1,500 to S. Green and billed that amount subject to terms 2/10, n/30. 6 Sold goods to M. Munoz for $850 and billed that amount subject to terms 2/10, n/30. 14 Collected cash due from S. Green. Feb. 2 Collected cash due from M. Munoz. 28 Sold goods for $400 to R. Reynolds and billed that amount subject to terms 2/10, n/45. Required: Assuming that Sales Discounts is...
1.The manufacturer of cans of salmon that are supposed to have a net weight of 6...
1.The manufacturer of cans of salmon that are supposed to have a net weight of 6 ounces tells you that the net weight is actually a normal random variable with a mean of 5.98 ounces and a standard deviation of 0.12 ounce. Suppose that you draw a random sample of 44 cans. Find the probability that the mean weight of the sample is less than 5.94 ounces. Probability = 2.Scores for men on the verbal portion of the SAT-I test...
1. Which of the following bonds would have the highest percentage change in value if all...
1. Which of the following bonds would have the highest percentage change in value if all interest rates in the economy decrease by 1%? Group of answer choices 20-year, zero coupon bond. 20-year, 5% coupon bond. 10-year, zero coupon bond. 1-year, 10% coupon bond. 20-year, 10% coupon bond. 2. Suppose you are signing a loan contract of $65,000 at an interest rate of 8.5%. You must make 5 equal payments at the end of the year for 5 years. How...
On September 1, 2021, Daylight Donuts signed a $171,000, 6%, six-month note payable with the amount...
On September 1, 2021, Daylight Donuts signed a $171,000, 6%, six-month note payable with the amount borrowed plus accrued interest due six months later on March 1, 2022. Daylight Donuts should report interest payable at December 31, 2021, in the amount of: (Do not round your intermediate calculations.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT