Complete the cash flow spreadsheet, Financial Accounting

Assignment Help:

This lab assignment will correspond to developing a cash flow budget with an operating loan. There is on lab exercise listed below. Additionally, there are two assignment questions. Please complete the lab exercise in Excel. The assignment questions can be completed by hand or in Word. You make work with one other individual (no more than two people per team). Hand in one hard copy of Lab 4 per team to the instructor AND upload your Excel file to Angel by the due date.

1. Consider you are putting together a quarterly cash flow budget at the start of January for the up-coming year (called a projected cash flow). On the following page is an incomplete cash flow budget.  With the following information, complete the cash flow budget by developing an Excel spreadsheet.  Use the Lab 4 Excel file provided on the Angel web site.

  Use the input data worksheet in your formula for those data items given in the input data worksheet.

  The year starts with a $0 operating loan balance.
 
  The operating loan is a revolving line of credit with a $300,000 maximum loan balance.

  The operating loan has a 9% annual interest rate.
 
  You want a minimum of $25,000 cash available at the beginning of each quarter.
 
At the end of each quarter, any cash available over and above $25,000 is used to pay off the outstanding operating loan. Whenever funds are used to pay interest and principal, all accrued interest is paid first with the remaining funds applied to the outstanding principal balance.
 
In calculating interest owed on the operating loan, assume the amount borrowed in each quarter was borrowed on the first day of the first month in the quarter.  Also assume that any principal and interest payment made on the operating loan is made on the last day of the last month in the quarter that the repayment is made.

2. Complete the Cash Flow spreadsheet using appropriate formulas.


Related Discussions:- Complete the cash flow spreadsheet

Describe the diversification benefit, A)  A portfolio's daily changes have ...

A)  A portfolio's daily changes have a standard deviation of $15 million. Suppose the daily changes in the portfolio's value have a first order serial correlation of 0.25. Calculat

Ias1 contents of financial statements, IAS 1 contents of financial statemen...

IAS 1 contents of financial statements IAS 1 prescribes the contents of published financial statements. The major reports that are included as part of the published financial sta

Measure of return in percentage terms, Both IRR and ROCE tenders a relative...

Both IRR and ROCE tenders a relative measure of return in percentage terms a feature that is seen as attractive to managers who may perhaps have difficulty in interpreting the abso

Compute the present value, Q. Compute the present value? The offer for...

Q. Compute the present value? The offer for the manufacturing rights is for a ten-year period. Annual after-tax cash flow after Year 4 = $660000 Present value of this c

What is accounting, What is accounting? Accounting is concerned with an...

What is accounting? Accounting is concerned with analysing, collecting as well as communicating financial information. Purpose is to help people who use this info to make more

Illustration of consolidated cashflow statements, Illustration of consolida...

Illustration of consolidated cashflow statements The voice of the Nation Limited is a Nairobi based media company. Its Consolidated Income Statement for the year ended 30 April

Determine the cost of equity, Lockheed Martin's management wishes to fi...

Lockheed Martin's management wishes to find out whether they have excess debt capacity. Its current market value of equity is $40 b and its book value of debt is $

expected range of returns, Series Arithmetic Mean Standa...

Series Arithmetic Mean Standard Deviation   Small-company stocks 15.9  % 32.8  %   Large-company

Important points for holding company with subsidiary , Important points for...

Important points for holding company with subsidiary The following points are important: 1) The first approach is to determine the effective shareholding by the holding compan

Cash flow, Please use the budget information in Assignment 7.1-case to prep...

Please use the budget information in Assignment 7.1-case to prepare the budget in the Excel document Assignment 7.1-budget and cash flow.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd