Reference no: EM1353417
Joe's Lawn Service has asked you to create various financial spreadsheets and a written memo to help him understand his finances for his business.
Create an Excel spreadsheet with formulae to demonstrate the following examples. Be sure to clearly label each example by using a different spreadsheet tab:
· Example 1 (Trade Discount, refer to Chapter 8): Using Excel formulae, calculate the discount of a mower that lists for $1,217 with the trade discount series of 15/4/1. Display formulae for each discount series as well as the final price of the item after all discounts have been applied.
· Example 2 (Depreciation, refer to Chapter 16): Create a depreciation schedule, using the sum-of-the-years'-digits method, for a mower that costs $1,217 with a salvage value of $150 with an expected life of 7 years
· Example 3 (Financial Statement, refer to Chapter 20): Prepare the following horizontal analysis of a balance sheet into Excel. Complete the information on total assets, total liabilities and owner's equity, increase and percent increase by using formulae in Excel. Be sure to format the percent increase (decrease) column to a decimal with one decimal place.
After creating the spreadsheet with the three examples above, write a memo that addresses the following points for Joe's questions and his files:
Explain what a trade discount is and why would Joe offer these.
Explain what is depreciation and why it is more applicable for Joe to use sum-of-the-years'-digits method versus the straight-line method.
Explain to Joe why he would want to prepare a horizontal analysis, such as what does the percent increase (decrease) column tell him about his assets and liabilities from years 2008 to 2009, and give suggestions on what he should do based on this analysis.
Joe's Lawn Service
Balance Sheet
2009
2008
Amount Increase (decrease)
Percent increase (decrease)
Assets
Cash
$10,814
$8,403
Accounts receivable
385
278
Inventory
857
1,098
Equipment
1,285
1,192
Total assets
Liabilities
Accounts payable
$9,597
$8,711
Wages payable
587
1,118
Total liabilities
Owner's equity
3,157
1,142
Total liabilities and owner's equity
|
Explain how do you think a wbs should be created
: Explain How do you think a WBS should be created and what stakeholders or team members should be involved
|
|
What she hired a fourth worker her total product increased
: When she hired a fourth worker, her total product increased but by only 1,000 bullfrogs. Yolanda pays $1,000 a week for equipment and $500 a week.
|
|
How would the electric force be affected
: A charge of +2q is fixed to one corner of a square, while a charge of -1q is fixed to the diagonally opposite corner. Expressed in terms of q, what charge should be fixed to the center of square, so the potential is zero at each of the two empty c..
|
|
Explain is any outcome generated by a nash equilibrium
: Explain is any outcome generated by a Nash equilibrium not generated by any subgame perfect equilibrium.
|
|
Sum of years digits method versus straight line method
: Joe's Lawn Service has asked you to develop many financial spreadsheets and a written memo to help him understand his finances for his business.
|
|
Create application uses two-dimensional arrays
: Create an application which uses 2-dimensional arrays to keep track of 5 students' grades, with each student having 3 different classes.
|
|
Define the term personality disorders
: How would you define personality disorders? What is an example of a personality disorder? Is it possible to manage and effectively treat this disorder? Why or why not?
|
|
What is the cars speed at the bottom of the dip
: In a nuclear experiment a proton with kinetic energy 1.5 MeV moves in a circular path in a uniform magnetic field. What energy (in MeV) must (a) an alpha particle (q = +2e, m = 4.0 u) and (b) a deuteron (q = +e, m = 2.0 u) have if they are to circ..
|
|
Illustrate what will happen to equilibrium price
: Illustrate what will happen to equilibrium price As a local cable company offers cheaper pay- per-view films, local movie theaters have more unfilled seats.
|