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)?

Please

St. Thomas University (STU) plans to build an addition to the Gus Machado School of Business 4 years from today. It will need to have $8 million in an account at that time. It plans to deposit $5 million into an account today to meet this need. What annual rate of interest must it earn on this deposit?

The owner of a bicycle repair shop forecasts revenues of $240,000 a year. Variable costs will be $70,000, and rental costs for the shop are $50,000 a year. Depreciation on the repair tools will be $30,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.

Give complete solutions and draw a cashflow diagram. Provide an amortization schedule 1. You have a car loan of $15,000 with an annual interest rate of 8%. The loan term is 3 years. Calculate the outstanding balance after 2 years of making monthly payments.

You recently purchased an office building for $1,950,000 using the following loan terms: 70% LTV, 20-year amortization, 6.25% interest and monthly compounding. Assuming a net operating income of $150,000 in Year 1 and income taxes equal to $11,000, what is the expected ATCF from Operations in Year 1?

A company has had record profits and decided to use some of the profits to pay for manufacturing improvements. If the company can invest $1,600,000.00 in an a annuity will that will make payments at the beginning of every six months for 4 years. If the annuity pays 5.6%, compounded semi-annual. What is the size of payments that the company can expect?The payment amount will be $. (Round to 2 decimal places.)

Can someone please help me to solve the following question showing all work and formulas neatly. And please show the cash flow diagram as well. PLEASE ANS THANK YOU!!!!!

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)

Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000, and the remainder is financed at (15) percent compounded semi-annually with semi-annual payments over 4 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows  a) Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.  b) Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period.  c) Plan 3: Make equal end-of-period payments.  d) Plan 4: Make a single payment of principal and interest at the end of the loan period.  e) A different plan: Pay off the principal in such a way that it is X, 1.5X, 2X, 2.5X... till the end of the last payment period. In addition, pay the accumulated interest at the end of each interest period.