Granite City Books Financing Options For Expansion As Of December 31 2013 000 S

Granite City County is Planning a 2.5 million expansions of its facilities. It needs to evaluate its options for financing the expansion. The company’s bank might not allow it to obtain more long term debt financing if its debt to equity ratio gets too high. Alternatively, common stockholders might be displeased if their ownership rights become diluted by issuing a substantial amount of preferred stock, or even additional common stock if it’s not issued on a pro ratio basis. A workbook has been started that contains a basic Balance sheet, solvency, and capital structure ratio data. Your task is to create scenarios for each financing alternative and prepare reports that Granite City Books bank ad management can use to compare the various financing alternatives. Complete the following.

1.       Open the workbook named Grantie xlsx. Located in the Chapter 8 folder, and save it as Grantie City Expansion.xlsx in the same location.

2.       In the options worksheet, apply appropriate names to the worksheet’s scenario changing cells as described in Table 8.5

Table 8.5 Descriptions of the changing cells

F9 Change in assets

F12 Change in long term debt

F14 Change in the dollar amount of common stock issued

F15 Change in the dollar amount of preferred stock issued                                                                                           

3.       Create four scenarios in the Options worksheet using the scenario names and changing cell values shown in Table 8.6

Changing cells   Long term debt financing   Common stock financing   Preferred stock fin.  Balance Fin.

F9                          2,500                                      2,500                                          2,500                      2,500

F12                        2,500                                           0                                               0                             1,000

F14                           0                                           2,500                                            0                            750   

F15                           0                                               0                                              2,500                      750

4.       Based on the information in Table 8.7, apply appropriate names to worksheet’s results cells.

Table 8.7 Descriptions of the results cells

Cells                   Descriptions of the results of cells.

F13                      Change in total liabilities

F17                      Change in total equity 

G21                     Debt-to-equity ratio

G24                   long-term-debt-to-common-equity ratio

G25                    Preferred stock ratio

5.       Create a professional-looking scenario summary report that shows all the results cells listed in Table 8.7

6.       Create a professional-looking scenario PivotTable that shows the last three results cells listed in Table 8.7. Also generate a PivotChart based on the Pivot Table.

7.       Save and Close the Granite City Expansion.xlsx workbook

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Granny Mae Has Been Helping Her Favorite Grandchild Save

Granny Mae has been helping her favorite grandchild save. She has given you $1 each year on your birthday, starting when you turned one, and taken you to deposit it in your bank account, which earns 4 percent each year. You have not deposited or withdrawn any othermoney. You just turned 21. However, Granny Mae is forgetful, and she forgot to give you money on your 10th and 20th birthdays. How much is in your account today?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Granny S Custom Quilts Receives An Order For A Patchwork Quilt Made From Square

Granny’s Custom Quilts receives an order for a patchwork quilt made from square patches of three types: solid green, solid blue, and floral. The quilt is to be 10 squares by 12 squares, and there must be 19 times as many solid squares as floral squares. If Granny’s charges $5 per solid square and $7 per floral square, and if the customer wishes to spend exactly $612, how many of each type of square may be used in the quilt? Let x be the number of green squares, y the number of blue squares, and z the number of floral squares.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Deeded His Property To Botts For Botts S Life The Terms In The Deed Stated

Grant deeded his property to Botts for Botts’s life. The terms in the deed stated that the property would pass to Grant’s son at the expiration of the life estate.

a.The future interest is a reversion estate.

b.The future interest is a remainder estate.

c.Grant’s son has dower to the estate.

d.Botts will own a leasehold estate.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Industries A Manufacturer Of Electronic Parts Has Recently Received An Inv

Required

1. What would be the Relevant cost per unit if the order is accepted at the price recommended by the sales manager? What do you think the minimum (short-term) bid price should be?

2. What would the total opportunity cost be if by accepting the special order the company lost sales of 6,900 units to its regular customers? Assume the preceding facts plus a normal selling price of $24 per unit.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Proposal Project Presentation For Smorgaschorus Men S Acapella Group From

Grant Proposal Project: Presentation for SmorgasChorus(Men’s acapella group) from Fred and Mary Koch Foundation 

Grant applying link: http://fmkfoundation.org/grants/ (Links to an external site.)

The mission statement of the SmorgasChorus is to enrich our community through music, support music education, encourage and preserve the barbershop art form and inspire our young members to be excellent through music.  Our members hail from all corners of the states of Kansas, Nebraska, and Oklahoma and were brought together by their love of music and their ties to the music department at Butler Community College in El Dorado, Kansas.

The South Central Kansas SmorgasChorus is an official chapter of the Barbershop Harmony Society and is a 501(c)3 non-profit organization.

https://www.smorgaschorus.net/ (Links to an external site.)Links to an external site.

https://www.facebook.com/smorgaschorus (Links to an external site.)Links to an external site.

https://www.facebook.com/groups/180819161940655/ (Links to an external site.)

Requirement 10 slides

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Proposal Topic My Project Idea Is Developing A Grant That Will Assist With

GRANT PROPOSAL TOPIC

***My project idea is developing a grant that will assist with disruptive/unruly high school students. Once this proposal is developed and funded it will assist schools and their teachers with methods that will allow them to be more in control of their classrooms which will ultimately promote effectiveness and a higher graduation rate. Better classroom management techniques will be more appealing to stakeholders and other organizations because it will make education in the public school system more marketable when compared to private schools.

****** Please see the attached example sent by the teacher. This assignment needs to be set up like the provided example. Make sure to focus on teachers with disruptive students and how to solve/correct the problem. Include resources that you have found with pertinent information******

Assignment 1: Final Project: Writing the Grant Part 1: Needs Statement, Goals, and Objectives

This week, you begin work on your Final Project. The Final Project consists of three written assignments that culminate in the submission of your grant proposal to your Instructor in Module 6. Parts 1, 2, and 3 will focus on major elements required of all proposals. In the final Grant Proposal Submission, incorporating the cumulative feedback you receive from your Instructor, you will compile these elements into your grant proposal.

The three parts of the Final Project are:

  •  Part 1: Needs Statement, Goals, and Objectives (Due Module 2)

For this Assignment:

  •  Review the Final Project Guidelines located in this module’s Learning Resources.
  •  Download a copy of your selected RFP. You will use this document to guide, focus, and support the development of all parts of your Final Project. Keep in mind as you complete your Final Project assignments that you are writing in accordance with the requirements of the RFP. You must also include the use of evidence-based practice in the literature review.
  •  Consider feedback to Discussion 1 from colleagues and your Instructor and your continued evaluation of the literature and funder guidelines; then finalize your needs statement, project goals, and objectives.
  •  Keep in mind that the needs statement must prove that it addresses funder interests as well as establish the specific problem the proposal will address.

Keep in mind that objectives must be specific and measurable and lead directly to your goals.

In 3–4 pages, excluding APA references, address the following:

  •  Write your Needs Statement. Substantiate the need by presenting proof of need. Keep in mind that the Needs Statement must reflect best practices in grant writing.
  •  Next, using bullets, list your goals, then your objectives, and finally your evaluation criteria for each one.

*Goal #1

*Goal #2

*Goal #3

*Objective 1

*Objective 2

*Objective 3

*Evaluation Criteria #1,n

*Evaluation Criteria #2,n

*Evaluation Criteria #3,n

It is imperative that your needs statement, goals, objectives, and evaluation criteria align.

For example, Goal #1, Objective #1, and Evaluation Criteria #1 must align and collectively meet the needs statement.

When developing your objectives, use the SMART objectives framework; list each of your project objectives.

  •  Project objectives must be specific.
  •  Project objectives must be measurable.
  •  Project objectives must be achievable.
  •  Project objectives must be realistic.
  •  Project objectives must be time-based.

References

Gitlin, L. N., & Lyons, K. J. (2014). Successful grant writing: Strategies for health and human service professionals (4th ed.). New York, NY: Springer.

  •  Chapter 5, “Common Sections of Proposals,” pp. 79–104
  •  Chapter 6, “Strategies for Effective Writing,” pp. 105–115
  •  Chapter 7, “Common Pitfalls in Proposal Writing,” p. 117–124
  •  Chapter 8, “Writing Considerations for Specific Research Proposals,” pp. 125–133

Blanco, M. A., Gruppen, L. D., Artino, A. R., Jr., Uijtdehaage, S., Szauter, K., & Durning, S. J. (2015). How to write an educational research grant: AMEE Guide No. 101. Medical Teacher, 38(2), 113–122. doi:10.3109/0142159X.2015.1087483

https://www.cdc.gov/phcommunities/resourcekit/evaluate/smart_objectives.html

https://ctb.ku.edu/en/applying-for-grants

https://www.cdc.gov/healthyyouth/evaluation/pdf/brief3b.pdf

Devine, E. B. (2009). The art of obtaining grants. American Journal of Health-System Pharmacy, 66, 580–587. doi:10.2146/ajhp070320

Logic Models

https://www.atcmag.com/Issues/ID/155/Making-Your-Grant-Proposal-Persuasive

Stokes, K. (2012). Writing clear statements of needs and goals for grant proposals. AMWA Journal: American Medical Writers Association Journal, 27(1), 25–28.

https://www.aacu.org/sites/default/files/LogicModel.pdf

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Proposal Topicmy Project Idea Is Developing A Grant That Will Assist With 1

GRANT PROPOSAL TOPIC

My project idea is developing a grant that will assist with disruptive/unruly high school students. Once this proposal is developed and funded it will assist schools and their teachers with methods that will allow them to be more in control of their classrooms which will ultimately promote effectiveness and a higher graduation rate. Better classroom management techniques will be more appealing to stakeholders and other organizations because it will make education in the public school system more marketable when compared to private schools.

Discussion: Writing Goals and Objectives for Your Grant

A goal is a general statement of what you hope to accomplish with your grant. In grant writing, there are 2-5 goals. Goals are broad generalizations and are abstract, not measurable. Each goal is about the outcome or impacts your grant-funded health education program is going to accomplish. In your goals, you want to catch the eye of the grant reviewers. Your goals must loop back to your needs statement.

An objective is directly tied to the goal the grant seeker is trying to achieve through grant funding opportunities. Objectives are very targeted and include the outcome(s) that will help accomplish the goal the objective addresses. In grant writing, SMART objective writing application should always apply. SMART stands for specific, measurable, achievable, realistic, and time-phased. There should be 2-5 objectives for each goal, and there should be enough objectives to accomplish the goal.  

Below is an example goal and an objective for a goal.

Goal #1: Increase physical activity in children and their parents in Wilmington, Delaware through the “Walking for Life” health education program.

Objective 1A: At the end of the first six months of the “Walking for Life” health education program, 100 parents and their children will increase their daily physical activity to walking at least one mile.

For this week’s discussion board, you will be sharing your health education program’s needs statement, two goals, and two objectives. Ensure all parts of the posting are aligned to guidelines and requirements contained in the RFP.

Note: To be respectful of your peers, in providing feedback that will be useful to them as they finalize their Needs Statement, Goals, and Objectives for Assignment 1, you are encouraged to post your responses to your colleagues by Day 5.

Post the following:

  • Your Needs Statement, Goals and Objectives.
  • Please use the following templates to develop your goals and objectives.
  • To develop a goal, use the template below and fill in the blanks and create a sentence:
  • __________________ 
  • (Increase or decrease)
  • __________________
  • (what)
  • __________________ 
  • (in whom)
  • __________________ 
  • (where)
  • __________________.
  • (in the name of your health education program).
  • To develop SMART objectives, use the template below and fill in the blanks and create a sentence:
  • By_____/_____/_____, 
  • WHEN—Time bound
  • _____________________________________________
  • WHO/WHAT—-Specific
  • from _____________________ to __________________________.
  • MEASURE with a number, rate, percentage of change, or baseline—Measurable

Be sure to support your analysis and conclusions with citations and references in APA format from the Learning Resources and your own research.

References

Gitlin, L. N., & Lyons, K. J. (2014). Successful grant writing: Strategies for health and human service professionals (4th ed.). New York, NY: Springer.

  • Chapter 5, “Common Sections of Proposals,” pp. 79–104
  • Chapter 6, “Strategies for Effective Writing,” pp. 105–115
  • Chapter 7, “Common Pitfalls in Proposal Writing,” p. 117–124
  • Chapter 8, “Writing Considerations for Specific Research Proposals,” pp. 125–133

Blanco, M. A., Gruppen, L. D., Artino, A. R., Jr., Uijtdehaage, S., Szauter, K., & Durning, S. J. (2015). How to write an educational research grant: AMEE Guide No. 101. Medical Teacher, 38(2), 113–122. doi:10.3109/0142159X.2015.1087483

https://www.cdc.gov/phcommunities/resourcekit/evaluate/smart_objectives.html

https://ctb.ku.edu/en/applying-for-grants

https://www.cdc.gov/healthyyouth/evaluation/pdf/brief3b.pdf

Devine, E. B. (2009). The art of obtaining grants. American Journal of Health-System Pharmacy, 66, 580–587. doi:10.2146/ajhp070320

Logic Models

https://www.atcmag.com/Issues/ID/155/Making-Your-Grant-Proposal-Persuasive

Stokes, K. (2012). Writing clear statements of needs and goals for grant proposals. AMWA Journal: American Medical Writers Association Journal, 27(1), 25–28.

https://www.aacu.org/sites/default/files/LogicModel.pdf

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grant Proposal Topicmy Project Idea Is Developing A Grant That Will Assist With

GRANT PROPOSAL TOPIC

My project idea is developing a grant that will assist with disruptive/unruly high school students. Once this proposal is developed and funded it will assist schools and their teachers with methods that will allow them to be more in control of their classrooms which will ultimately promote effectiveness and a higher graduation rate. Better classroom management techniques will be more appealing to stakeholders and other organizations because it will make education in the public school system more marketable when compared to private schools.

Assignment 1: Final Project: Writing the Grant Part 1: Needs Statement, Goals, and Objectives

This week, you begin work on your Final Project. The Final Project consists of three written assignments that culminate in the submission of your grant proposal to your Instructor in Module 6. Parts 1, 2, and 3 will focus on major elements required of all proposals. In the final Grant Proposal Submission, incorporating the cumulative feedback you receive from your Instructor, you will compile these elements into your grant proposal.

The three parts of the Final Project are:

  • Part 1: Needs Statement, Goals, and Objectives (Due Module 2)
  • Part 2: Methodology and Evaluation Plans (Due Module 2)
  • Part 3: Budget, Budget Narrative, and Sustainability Plan (Due Module 3)

The final Grant Proposal Submission is due in Module 6.

For this Assignment:

  • Review the Final Project Guidelines located in this module’s Learning Resources.
  • Download a copy of your selected RFP. You will use this document to guide, focus, and support the development of all parts of your Final Project. Keep in mind as you complete your Final Project assignments that you are writing in accordance with the requirements of the RFP. You must also include the use of evidence-based practice in the literature review.
  • Consider feedback to Discussion 1 from colleagues and your Instructor and your continued evaluation of the literature and funder guidelines; then finalize your needs statement, project goals, and objectives.
  • Keep in mind that the needs statement must prove that it addresses funder interests as well as establish the specific problem the proposal will address.

Keep in mind that objectives must be specific and measurable and lead directly to your goals.

In 3–4 pages, excluding APA references, address the following:

  • Write your Needs Statement. Substantiate the need by presenting proof of need. Keep in mind that the Needs Statement must reflect best practices in grant writing.
  • Next, using bullets, list your goals, then your objectives, and finally your evaluation criteria for each one.

*Goal #1

*Goal #2

*Goal #3

*Objective 1

*Objective 2

*Objective 3

*Evaluation Criteria #1,n

*Evaluation Criteria #2,n

*Evaluation Criteria #3,n

It is imperative that your needs statement, goals, objectives, and evaluation criteria align.

For example, Goal #1, Objective #1, and Evaluation Criteria #1 must align and collectively meet the needs statement.

When developing your objectives, use the SMART objectives framework; list each of your project objectives.

  • Project objectives must be specific.
  • Project objectives must be measurable.
  • Project objectives must be achievable.
  • Project objectives must be realistic.
  • Project objectives must be time-based.

References

Gitlin, L. N., & Lyons, K. J. (2014). Successful grant writing: Strategies for health and human service professionals (4th ed.). New York, NY: Springer.

  • Chapter 5, “Common Sections of Proposals,” pp. 79–104
  • Chapter 6, “Strategies for Effective Writing,” pp. 105–115
  • Chapter 7, “Common Pitfalls in Proposal Writing,” p. 117–124
  • Chapter 8, “Writing Considerations for Specific Research Proposals,” pp. 125–133

Blanco, M. A., Gruppen, L. D., Artino, A. R., Jr., Uijtdehaage, S., Szauter, K., & Durning, S. J. (2015). How to write an educational research grant: AMEE Guide No. 101. Medical Teacher, 38(2), 113–122. doi:10.3109/0142159X.2015.1087483

https://www.cdc.gov/phcommunities/resourcekit/evaluate/smart_objectives.html

https://ctb.ku.edu/en/applying-for-grants

https://www.cdc.gov/healthyyouth/evaluation/pdf/brief3b.pdf

Devine, E. B. (2009). The art of obtaining grants. American Journal of Health-System Pharmacy, 66, 580–587. doi:10.2146/ajhp070320

Logic Models

https://www.atcmag.com/Issues/ID/155/Making-Your-Grant-Proposal-Persuasive

Stokes, K. (2012). Writing clear statements of needs and goals for grant proposals. AMWA Journal: American Medical Writers Association Journal, 27(1), 25–28.

https://www.aacu.org/sites/default/files/LogicModel.pdf

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"