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...
Danner Company expects to have a cash balance of $53,100 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $53,100 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $100,300, February $177,000. Payments for direct materials: January $59,000, February $88,500. Direct labor: January $35,400, February $53,100. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,780, February $29,500. These costs include depreciation of $1,770 per month. All other overhead costs are paid as incurred....
Evaluate a project that has a startup cost of $10,000, a projected cash flow of $3,000...
Evaluate a project that has a startup cost of $10,000, a projected cash flow of $3,000 at the end of the first year, $4,200 the second year, and $6,800 in the third and final year. Use 10% as the required rate/cost of capital 1. Use the XNPV function to calculate the Net Present Value for the project in.  Use today's date as the start date T0, and the same date a year later for T1 and so on. 2. Use the...
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...
1-You have $46,605.46 in a brokerage account, and you plan to deposit an additional $3,000 at...
1-You have $46,605.46 in a brokerage account, and you plan to deposit an additional $3,000 at the end of every future year until your account totals $290,000. You expect to earn 10% annually on the account. How many years will it take to reach your goal? Round your answer to the nearest whole number. 2- You want to buy a car, and a local bank will lend you $25,000. The loan will be fully amortized over 5 years (60 months),...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT