Construct a spreadsheet model to examine aunty may

Assignment Help Financial Accounting
Reference no: EM132974259

Aunty May has taken a loan from the bank to start a new business. She expects a first year revenue of $50,000 and, thereafter, revenue growing at 8% per year. Her non loan expenses are initially $30,000 per year and this grows at 4% per year. Her loan repayment is $25,000 per year for 5 years.

Problem a. Construct a spreadsheet model to examine Aunty May's business financials.

Problem b. Is the business viable within the first 8 years? When does it break even?

Problem c. Do you think the loan amount is sufficient for overcoming cashflow concerns? How do you know?

Problem d. What if the first-year revenue is $45,000, growing at 7%; first-year expense is $25,000, growing at 3%; and loan repayment is $20,000 per year for 5 years?

Reference no: EM132974259

Questions Cloud

Calculate expected gain or loss per share : Calculate your expected gain (or loss) per share. The next dividend is due in 3 months. They pay a dividend of $0.30 each quarter.
Find how much would be willing to pay today for company : Your company is looking at building a hydroelectric dam. How much would they be willing to pay today if they want to earn j12 = 10.0% on their money?
What would be the one year holding period return : What would be the one Year Holding Period Return? If you owned 1000 shares of TGT what would have been your capital gain/loss?
Describe the available methods that may be used : Describe each of the available methods that may be used. (Survey, Interview)
Construct a spreadsheet model to examine aunty may : What if the first-year revenue is $45,000, growing at 7%; first-year expense is $25,000, growing at 3%; and loan repayment is $20,000 per year for 5 years?
What are the different types of modified audit opinions : What are the contents of an unmodified auditor's report and What is the difference between an unmodified auditor's opinion and a modified auditor's opinion
Make the required journal entries in the proper format : Parker Dry Cleaning Services, Make the required journal entries (in the proper format) for each transaction listed above in the space provided.
What is the carrying amount of notes payable on December : The entity will continue to collect the assigned accounts receivable. What is the carrying amount of notes payable on December 31, 2019
Prepare the adjusting journal entries for tag company at dec : The company completed $7,000 worth of services that they had not invoiced the customer for. Prepare the required adjusting entry at 12/31/15.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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