DGE purchased a cement truck for $120,000. It is expected to last N=4 years. The $120,000 was borrowed from the bank at 10% interest per year compounded annually and payments are paid annually from DGE to the bank. The loan will be fully repaid in 4 years. CCA rate is 35%. Tax Rate is 40%. Answer the following questions with regards to Income Statements and Cash Flow Statements. Develop the cash flow/ investment including as many details as possible. What is the net cash flow over 6 years  a. If there were working capital (WC) required for this project, which year or years does it show up in the statement(s)?

Consider the following data showing the cash flows per year from a real estate property: Year: 1 2 3 4 5 Cash Flow: $21,000 $22,000 $23,000 $24,000 $25,000 After the 5th year, cash flows are expected to rise at a constant rate of 2.5% per year for the many years in the future. Your cost of money (interest paid on the loan) is 5.5% per year. A. Calculate the appraisal value of the house. B. Define and calculate the cap rate. Explain what it means. (Answer with respect to Excel for both)

The owner of a bicycle repair shop forecasts revenues of $160,000 a year. Variable costs will be $50,000, and rental costs for the shop are $30,000 a year. Depreciation on the repair tools will be $10,000. Prepare an income statement for the shop based on these estimates. The tax rate is 20%.   Calculate the operating cash flow for the repair shop using the three methods given below: Dollars in minus dollars out. Adjusted accounting profits. Add back depreciation tax shield.

In the provided scenario, you address the time value of money also known as discounted cash flow analysis. This type of analysis is crucial to being able to viably analyze financial statements. The start - up firm you founded is trying to save $10, 000 in order to buy a parcel of land for a proposed small warehouse expansion. In order to do so, your finance manager is authorized to make deposits of S 1250 per year into the company account that is paying 12% annual interest. The last deposit will be less than $1250 if less is needed to reach $10,000. How many years will it take to reach the $10,000 goal and how large will the last deposit be? Show your work

You have a chance to invest in a shopping center. The total investment for the purchase of the land and construction of the center is $10,000,000 today. You have calculated the yearly net after tax cash flows from operations as follows: Year 1: $1,500,000 Year 2: 2,000,000 Year 3: 2,250,000 Year 4: 2,500,000 Year 5: 2,750,000 At the end of year 5 you will sell the shopping center for $18,000,000 after taxes. Required: |+ Use the provided Excel spreadsheet to calculate the present value of all the operating after-tax cash flows and the total cash flows for the project assuming you require an 20% R.O.I. Use the attached "PRESENT VALUE TABLE" for your calculations:

The owner of a bicycle repair shop forecasts revenues of $196,000 a year. Variable costs will be $59.000, and rental costs for the shop are $39.000 a year. Depreciation on the repair tools will be $19.000. a. Prepare an income statement for the shop based on these estimates. The tax rate is 20% Calculate the operating cash flow for the repair shop using the three methods given below Now calculate the operating cash flow 1. Dollars in minus dollars out 2. Adjusted accounting profits, in 3.Add back depreciation tax shield