Question

In: Finance

1. Orlando expects to have a monthly cash flow of $ 3,000 after taxes. Additional has...

1. Orlando expects to have a monthly cash flow of $ 3,000 after taxes. Additional has the following monthly expenses: Rent $ 750, student loan payment $ 200, utilities $ 150, food $ 300, recreation $ 600, vehicle expenses $ 200 and purchase of clothing $ 150. What is your "net cash flow" for the current month?

2. If Gustavo wants to have $ 25,000 in 5 years and can get an 8% interest, how much will he need to invest today?

3. How much money will you have if you invest $ 75 per month, for 36 months, compounded annually at 10%?

Solutions

Expert Solution

1. Calculation of Net cash flows

Cash Flows after taxes = 3000

Total of monthly expenses

Rent 750 + Student loan 200 + Utilities 150 + Food 300 + recreation 600 + vehicles expenses 200 + purchase of clothing 150 = 2350.

Net cash flows = Cash inflow - Monthly expenses

= 3000 - 2350

= 650

2. You need to calculate the present value of 25000 , Period = 5 years Interest =8%

PV = FV / (1+r)n

= 25000 / (1.08)5

= 25000 / 1.46932808

= 17014.58 approx

$17014.58 approx need to deposit today to get the 25000 in 5 years at 8% interest.

3. Monthly payment = 75, No fo periods = 36, rate 10% compounded annuly.

You need to calculate the monthly rate for this.

= (1.10)1/12 - 1

= 1.00797414 - 1

= 0.797414%

Now calculate Fv. As factors might not avialable in table for this rate. So use excel or financial calculator to solve this.

Put values in texas ba 2 in TVM as N=3, I/Y = 0.797414%,PMT =75, PV =0, Compute fv= 3113.19

You will have 3113.19 approx. after 36 months.


Related Solutions

Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable,...
Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable, $135,000; and Accounts payable, $100,000. Its budgeted sales, merchandise purchases, and various expenses for the next three months follow. July August September Sales $220,000 $300,000 $380,000 Merchandise purchases 210,000 180,000 220,000 Payroll, rent, and other expenses 96,000 41,000 51,000 20% of the sales are for cash. Of the remaining credit sales, 30% are collected in the same month as the sale, and 70% are...
Martin Company expects to have a cash balance of $135,000 on January 1, 2017. Relevant monthly...
Martin Company expects to have a cash balance of $135,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows: Collections from customers: January $246,500, February $435,000. Payments for direct materials: January $155,000, February $240,000 Direct labor: January $90,000, February $135,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $63,000, February $75,000. These costs include depreciation of $5,000 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $45,900 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,900 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $86,700, February $153,000. Payments for direct materials: January $51,000, February $76,500. Direct labor: January $30,600, February $45,900. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,420, February $25,500. These costs include depreciation of $1,530 per month. All other overhead costs are paid as incurred....
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: ● Collections from customers: January $249,800, February $442,100. ● Payments for direct materials: January $156,600, February $246,700 ● Direct labor: January $91,700, February $136,600. Wages are paid in the month they are incurred. ● Manufacturing overhead: January $61,700, February $75,200. These costs include depreciation of $4,900 per month. All other overhead costs...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: ● Collections from customers: January $249,800, February $442,100. ● Payments for direct materials: January $156,600, February $246,700 ● Direct labor: January $91,700, February $136,600. Wages are paid in the month they are incurred. ● Manufacturing overhead: January $61,700, February $75,200. These costs include depreciation of $4,900 per month. All other overhead costs...
MIDSTRATA Co. has $3 million of extra cash after taxes have been paid. It has two...
MIDSTRATA Co. has $3 million of extra cash after taxes have been paid. It has two choices to make use of this cash. First alternative is to invest the cash in financial assets. The resulting investment income will be paid out as a special dividend at the end of three years. In this case, the firm can invest in Treasury bills yielding 3% or a 5% preferred stock. CRA regulations allow the company to exclude from taxable income 100% of...
Chipotle expects to earn a free cash flow of $500 in 1 year; further, these cash...
Chipotle expects to earn a free cash flow of $500 in 1 year; further, these cash flows are expected to grow at a rate of 3% forever. The discount rate on the burrito assets is 15%. Chipotle also has debt outstanding with a face value of $1000 and a maturity of 1 year, with an annual interest rate of 10% and a yield-to-maturity of 7%. After the debt matures in 1 year, Chipotle will not issue more debt. What is...
Hard Spun Industries (HSI) has a project that it expects will produce a cash flow of...
Hard Spun Industries (HSI) has a project that it expects will produce a cash flow of $2.9 million in 10 years. To finance the project, the company needs to borrow $1.7 million today. The project will also produce intermediate cash flows of $170,000 per year that HSI can use to service coupon payments of $85,000 every six months. Based on the risk of this investment, market participants will require a 11.0% yield. If HSI wishes a maturity of 10 years...
MIDSTRATA Co. has $3 million of extra cash after taxes have been paid. It has two choices to make use of this cash.
MIDSTRATA Co. has $3 million of extra cash after taxes have been paid. It has two choices to make use of this cash. First alternative is to invest the cash in financial assets. The resulting investment income will be paid out as a special dividend at the end of three years. In this case, the firm can invest in Treasury bills yielding 3% or a 5% preferred stock. CRA regulations allow the company to exclude from taxable income 100% of...
Suppose you have a project with a projected annual cash flow before interest and taxes of...
Suppose you have a project with a projected annual cash flow before interest and taxes of $6 million, indefinitely. The initial investment of $18 million will be financed with 60% equity and 40% debt. Your tax rate is 34%, your cost of capital if you were an all-equity firm is 24%, and your usual borrowing rate is 10%. Your project has been reviewed by your local city government and has been selected to receive municipal funding at a rate of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT