Reference no: EM131431443 , Length: word count:1400
Purpose of Assignment
Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and the electronic spreadsheet will automatically update itself.
Students will create a spreadsheet of computer equipment for a small fictional business where they are the owner. They will include the cost of all hardware and software needed for their employees, and calculate a monthly budget for the equipment.
Assignment Steps
Resources:
Research hardware and software to satisfy operational requirements described above
Microsoft Office 365, Office 2016: Introductory: Module 1: Creating a Worksheet and a Chart.
Microsoft Office 365, Office 2016: Introductory: Module 2: Formulas, Function, and Formatting.
Scenario: Imagine you are the owner of a small internet business where you employ five people. You need to budget for the cost of hardware and software needed to run company operations. Each employee is required to work both in the office and remotely, and needs access to company data at all times.
Choose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spreadsheet software applications.
Create a business budget sheet using Microsoft® Excel®. In the budget sheet, do the following:
List the make and model of desired hardware devices and their cost.
List software operating systems and applications for each device and their costs.
Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems.
Insert a graph or chart displaying total costs graphically.
Label columns/rows with titles reflecting data they contain.
Use no more than two sheets in one workbook to display required data.
Format data to highlight important totals.
The Budget sheet answers should include 1,400 words.
What is meant by nonforfeiture clauses
: What is meant by Nonforfeiture clauses? Why, mathematically, do some life insurance policies have nonforfeiture options (what feature of a policy allows for nonforfeiture options)? Provide three examples of nonforfeiture options.
|
How financial management techniques can be used
: Using each of the four categories of risk, develop an analysis of how financial management techniques or policies can be used to mitigate each of the risks.
|
How big was the target firm compared to the acquirer
: FIN 302- Identity of target firm and acquirer firm. What industry is each firm in? What was the market capitalization of each firm, prior to the merger announcement? How big was the target firm, compared to the acquirer?
|
Calculate the unsystematic risk and firm specific risk
: FINA 6001 Managing Finance Assignment. Calculate the daily market return over the last five years from the daily prices, calculate the monthly returns from the daily returns, and calculate the yearly returns from the monthly returns. Calculate the ..
|
List the make and model of desired hardware devices
: Choose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spread..
|
Regress the annual rate of exchange rate changes
: Regress the annual rate of exchange rate changes on the annual inflation rate differential toestimatethe intercept and the slope coefficient, and interpret the regression results.
|
What i have seen is exactly what this tedtalk explained
: What I have seen is exactly what this TedTalk explained. If they are confident in th entrepreneur, an offer will sometimes be made even if the product needs work.
|
Describe how the information given about consumer demand
: In each of the following examples, describe how the information given about consumer demand helped managers develop the appropriate strategies to increase profitability and how this information was obtained.
|
Calculate the dividend payout and dividend yield
: FINA 6001 Managing Finance Assignment. Provide answers to the following: Report the dividend payments over the last three years and Calculate the dividend payout and dividend yield
|