Reference no: EM13999783
The Use of Spreadsheets in Budgeting
The reports that are generated from accounting software are not always user friendly. In many cases, there is nowhere for a budget to be entered. What happens when you have an expense in a category where there was no budget? By using a spreadsheet program, such as Microsoft Excel, you can translate the report data into any format that you like. For example, you can group all of the different expense accounts based on a particular project. The possibilities are endless with the flexibility of a spreadsheet program.
Your assignment is to create a one-year budget (forecast) as a team in Excel, based on the real estate company you set up.
As a team you can decide when/if you would like to do the following real estate transactions. You will explain your decisions in your team's analysis paper.
Decisions:
Take cash/line of credit and purchase a complete one-bedroom, fixer-upper condo for $18,000. You will also need $7,000 to completely gut and rebuild the condo. This process will take one month after purchase; you are going to outsource the process.
If you choose to take out a line of credit, you would have a 0% financing offer up to $25,000 for 15 months. Remember you can also use cash. You decide what you would charge for rent and the HOA fees would be the same as the other condo you purchased. The property taxes are $1,676 annually (139.67 per month)
Would you like to sell any of the properties? If so which one and why? Currently the appraisal on the condo is $135,000 and the house is $70,800.
What about raising the rent on the properties?
Are there any other business decisions you would like to make?
|
What is balls speed at its highest point
: What is its speed at its highest point? Express your answer to two significant figures and include the appropriate units. How high does it go? Express your answer to two significant figures and include the appropriate units.
|
|
Government imposes a quantity tax on consumption of a good
: If the government imposes a quantity tax on the consumption of a good, it means that the consumer has to pay for each unit of the good its price plus the tax. For example, if the price of a chocolate bar is $5 and the government imposes a tax of 20 c..
|
|
Find the maximum velocity of the mass
: A 0.60-kg mass is connected to a spring of spring constant k = 40.0 N/m. What is the frequency of oscillation? Find the maximum velocity of the mass.
|
|
Develop a behaviorally anchored rating scale
: You are to use thejob description you wrote and develop a behaviorally anchored rating scale (BARS) to use as a performance appraisal document
|
|
What about raising the rent on the properties
: Would you like to sell any of the properties? If so which one and why? Currently the appraisal on the condo is $135,000 and the house is $70,800.
|
|
Profit contribution can par earn on production quantities
: Par Inc., is a small manufacturer of golf equipment and supplies. Par's distributor believes a market exists for both a medium-priced golf bag, referred to as a standard model, and a high-priced golf bag, referred to as a deluxe model. What profit co..
|
|
Discusses a recent crisis in the news
: Write a paper that discusses a recent crisis in the news and how it was handled from a PR standpoint (e.g. BP oli spill). How would you have handled the situation as a PR expert and Why? What tactics and techniques would you have used
|
|
Corporate governance issue important in recent dismissal
: The corporate governance issue most important in the recent dismissal of american apparel's founder as CEO involved,
|
|
Protozoa desires to obtain secret recipe for lobster patty
: Protozoa desires to obtain the secret recipe for a lobster patty that is known by Lobster who is Protozoa's biggest competitor. Protozoa has attempted to steal the recipe for years. What can Lobster do to protect his secret recipe
|