Simple balance sheet statement, Financial Accounting

Assignment Help:

Current analysis

You will need about $150,000 in start-up costs but you can only borrow half of that amount from your family's home equity (at 13% interest). You will have to borrow the rest of the needed capital from a local community bank at 10%. Suppose you decide to take out a 5 year loan. Here is the amortization schedule:

Date

Interest

Principal

Balance

Year 1

$13,904.46

$24,340.22

$125,659.78

Year 2

$11,355.72

$26,888.96

$98,770.83

Year 3

$8,540.10

$29,704.58

$69,066.24

Year 4

$5,429.64

$32,815.04

$36,251.20

Year 5

$1,993.48

$36,251.20

$0.00

 

Your estimated revenue per page of a medical record is 75 cents. The estimated processing cost per page is 20 cents

Marketing is expected to cost you $2,000 per year. So far, you only have two clients (two local hospitals) with combined annual discharges of 30,000. From your marketing efforts and word- of-mouth, you expect to gain 5,000 new discharges  each year over the next 5 years.

On average, you expect to release10 pages per discharge. You plan to pay yourself $85, 000 per year. You plan to hire a part-time clerk for every 15,000 discharges at $20,000 per year. You expect to pay $10,000 per year in equipment lease. For the next 5 years, your revenue and expenses  are expected to  increase by 3%, except the marketing costs (in other words, marketing will remain at $2,000 per year) Your tax rate is expected to stay at  35%

Questions 

1. What is your corporate cost of capital (CCC) on the day you start your business?

2. Construct a projected P&L statement in each year for next 5 years.

3. Construct a simple balance sheet statement in each year for next 5 years. Remember that Assets = Equity + Liabilities

4. Discuss about the Dupont equation of your company.

5.  What other financial measures can investors use to evaluate the profitability of your company?


Related Discussions:- Simple balance sheet statement

Product costs and which are period costs, The costs that follow were extrac...

The costs that follow were extracted from the accounting records of various different manufacturers: 1.    Weekly wages of an equipment maintenance worker 2.    Marketing costs

Use spreadsheet to determine allocation, The Red and Blue partnership has b...

The Red and Blue partnership has been created to operate a law firm. The partners have been attempting to devise a fair system to allocate profits and losses. Red plans to work mor

Estimate the cost, Olivia has received a $15 gift certificate that is redee...

Olivia has received a $15 gift certificate that is redeemable only for roasted peanuts. Bags of roasted peanuts come in two sizes, regular and jumbo. A regular bag contains 30 pean

Activity cost drivers, Activity Cost Drivers An element of measurement...

Activity Cost Drivers An element of measurement for the stage (or quantity) of an activity that is performed within a business company.  Hence, a movement cost driver represen

Change in profit sharing ratio, Change in profit sharing ratio When there...

Change in profit sharing ratio When there is a change in profit sharing ratio, it means that some of the partners will get higher profits based on the new ratios in the future wh

Items reducing the deficit-liquidation of companies, Items reducing the def...

Items reducing the deficit: Items reducing the deficit would include: (a)    Profits from trading; (b)    Estimated profit on the realisation of assets. Notes: (a) Whe

Prepare the necessary journal entries in 2013, Berg Company adopted a stock...

Berg Company adopted a stock-option plan on November 30, 2013, that provided that 73,200 shares of $5 par value stock be designated as available for the granting of options to offi

Trustees remuneration-trusts laws and accounts, Trustees remuneration A...

Trustees remuneration A trustee may not receive remuneration except: 1. By order of the court, if the trust is very onerous or the services of the trustee very valuable;

Qualitative characteristics , Since 1968, Dracula Limited has traded in Don...

Since 1968, Dracula Limited has traded in Doncaster, South Yorkshire as a manufacturer of fancy-dress and theatrical costumes. It produces a wide range of general theatrical costum

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